PPT 2007 Need To Programmatically Edit Data In WorkSheet Cells Behind The Chart
Posted on 2008-10-10
Up until now I have been generating PPT files by opening a PPT template,
pulling records from Access, and using VBA code to populate the tables and
graphs on the slides with data from the Access queries. The tables are easy,
while the graphs I updated by putting data values into the graph's datasheet
Now with PPT 2007 the graphs are different. The datasheet is more like an
Excel worksheet, with a "Chart" tab and a "Sheet1" tab at the bottom (or a split window). I have
tried every syntax I can think of to talk to this new type of datasheet using
VBA, but nothing works.
Now I read on various forums that the new PPT 2007 Chart object does not
expose any methods that can be addressed using VBA.
So I started writing an application to manipulate PPT slides using VB.Net.
But I cannot find any examples that show how to use VB.Net code to
programmatically update the data in the worksheet behind the chart.
What is the big secret to updating the sheet cells in PPT 2007 charts?
Where is the answer to this found in the documentation for the 2007 PPT object model? I cant believe the
ability to address datasheet cells direclty in code has been taken away.
Does anybody know how to do this without reverting back to the old MSGraph model?
Thanks for any help!