T
Todd Waldron
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
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