VBA, PowerPoint and Graphs

  • Thread starter Matthew Detzler
  • Start date
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 blindly.

Is there a book or snippet of code someone could recommend?

Unlike in Excel, simply turning on the macro recorder and "recording"
changing the data in a bar graph in PowerPoint doesn't really enlighten me on
what kind of command to use. The code I end up with is...


Sub Change Data()
ActiveWindow.Selection.SlideRange.Shapes("Object 1").Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1

End Sub

Any ideas or advice would be greatly appreciated.

Thanks,
Matt
 
M

Matthew Detzler

Perfect.. thanks a lot Steve

(BTW To all others, sorry for the multiple posts regarding this question the
MS site kept going cookie when I tried to post it saying it kept loosing the
connection)

Thanks again Steve.

-Matthew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top