M
Matthew Detzler
I'm looking into how to manipulate data and graphs within
powerpoint using VBA. I'm very proficient with VBA in Excel, but without
an "Intro to VBA PowerPoint" I have been flying blind.
Specifically I would like to change the data using VBA hence affecting a
graph such as a bar chart. To get an insight with Excel into the code I
would simply record a macro, but when I do such with PowerPoint all I get
is...
Sub ChangeBarChartData ()
ActiveWindow.Selection.SlideRange.Shapes("Object 1").Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1
ActiveWindow.Selection.Unselect
End Sub
If anyone has ideas for a good book that covers this or snippets of code
that handle data in graphs in PowerPoint using VBA it would be greatly
appreciated.
Thanks,
Matt
powerpoint using VBA. I'm very proficient with VBA in Excel, but without
an "Intro to VBA PowerPoint" I have been flying blind.
Specifically I would like to change the data using VBA hence affecting a
graph such as a bar chart. To get an insight with Excel into the code I
would simply record a macro, but when I do such with PowerPoint all I get
is...
Sub ChangeBarChartData ()
ActiveWindow.Selection.SlideRange.Shapes("Object 1").Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1
ActiveWindow.Selection.Unselect
End Sub
If anyone has ideas for a good book that covers this or snippets of code
that handle data in graphs in PowerPoint using VBA it would be greatly
appreciated.
Thanks,
Matt