Powerpoint to Excel

[njimack]

Every month, I receive a presentation which contains a number of embedded charts. I need to extract the data from these and into one of my Excel files.

Currently I'm doing this by hand - right-click chart, select Chart object>Edit, then copy data and paste into my file. I'm looking for way to automate this using Excel VBA. Should be possible but I've never coded in Powerpoint, not even sure how to retrieve the name of each chart.

Any help appreciated.

 

[_cytop]

Why not do the usual? Record a macro in Powerpoint while you retrieve the chart values and then see what the recorded macro reveals about the Powerpoint object model...?

You can then import that directly into Excel VBA with edits to suit.

It's not the complete answer you wanted, probably, but that's how I'd start something like this.

 

[njimack]

Been there, done that. The below code was generated by the macro recorder...

Sub Macro1()
'
' Macro recorded 05/10/2010 by Neil Jimack
'

    ActiveWindow.Selection.SlideRange.Shapes("Object 2").Select
    With ActiveWindow.Selection.ShapeRange
        .Left = 35.625
        .Top = 85.375
        .Width = 277.625
        .Height = 179.5
    End With
End Sub