Importing Excel Data into PPT using VBA

G

Guest

Hi all,

I'm running MS-Office 2003 and I have a PPT template (9 slides) that contain
fixed slide objects (text boxes, charts, graphs) where I need to frequently
update the data in the objects from an Excel data file using VBA.

I'm using MS-Access as the UI and COM controller; I've added the Excel and
PPT library references; through VBA - I've got working instances of the
applications, and successful connections to the Excel data file and the PPT
template.

The snag I've run into is I'm not sure how to refer to the chart/graph
objects to make updates. I've determined that the chart and graph object
types in my template are "Microsoft Graph Chart". What I want to do is
select a range from the Excel data file, copy, then paste the range into the
datasheet behind the respective chart/graph.

I recorded a macro for a graph in PPT where I manually accessed the
datasheet behind a graph object and typed in some data. I wanted to see if
it would show me how to refer to the graph object. Below is what the macro
wrote:

ActiveWindow.Selection.SlideRange.Shapes("Object 3").Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1
ActiveWindow.Selection.Unselect

Is there a way to determine the ID, Name, or Idex of the chart/graph objects
so I can call and update them? Is there an object library I can refer to for
"MS Graph Chart"?

Since I'm using MS-Access as the COM controller I found and added the
Microsoft Graph 11.0 Object Library (C:\Program Files\Microsoft
Office\Office11\graph.exe) just in case.

Any help would be greatly appreciated!

Thank you,

Todd Waldron
Austin, Texas
 
G

Guest

My apologies for the duplicate posting, please see my original post
"Importing Data From Excel into PPT Charts and Graphs using VBA".

Thanks,

Todd
 

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