VBA, PowerPoint and Graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Generally, once you get the references to the MSGraph chart object sorted out,
you can record chart fun and games in Excel and use a lot of the same code
directly in PPT.

There are a bunch of links here that should help get you cranking:

Automating MSGraph
http://www.rdpslides.com/pptfaq/FAQ00496.htm

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
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
 
Back
Top