Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PPT 2007 Need To Programmatically Edit Data In WorkSheet Cells Behind The Chart

Posted on 2008-10-10
4
Medium Priority
?
939 Views
Last Modified: 2012-06-27
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
cells.

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!
VITIX
0
Comment
Question by:VITIX
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:VITIX
ID: 22699621
After all the research I've done in the last 2 days, I think this question is more difficult than I had first guessed.

Anybody? Any way to make it possible to progammatically edit data in a PPT 2007 chart?
0
 
LVL 21

Accepted Solution

by:
GlennaShaw earned 1000 total points
ID: 22705502
You're not going to like this answer.  Quoted from: http://www.pptfaq.com/FAQ00889.htm
"Charts
If you need to automate charts in PowerPoint 2007, it'd be best if you change your name and move to another town where nobody knows that you do PowerPoint programming.
The chart objects you get in PowerPoint 2007 when you add a new chart expose no methods or properties to VBA. In short, you can't do anything with them."

On the other hand, there is this: http://msdn.microsoft.com/en-us/library/bb871574(VS.80).aspx
and this: http://msdn.microsoft.com/en-us/library/bb676881.aspx
0
 

Author Comment

by:VITIX
ID: 22716164
Yes, I saw the pptfaq pages. I also found that first link previously, but I did not find the second one regarding PPT automation with VS 2005.

That link pretty much sums it up. What I am asking cannot be done, and that link proves it, straight from the Microsoft horse's mouth!

Like it or not, there is my answer! Thanks for the info!
0
 

Author Closing Comment

by:VITIX
ID: 31505201
Provided a link to a Microsoft web page that hit the nail right square on the head! Not what I wanted to hear, but the information provided is correct and accurate and pertinent! So Thank You!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This video teaches viewers how to create handouts from their slides and helps them decide how many slides to include per handout.
The viewer will learn how to edit animations within the presentation, incorporate sound, and set everything up with timing.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question