Saving oleobjects inPowerPoint from vb.net

[JzP]

Hi,
I'm writing an application in vb.net (as a bit of a newbie) and need to
automate PowerPoint to add data to slide templates.
My code from the form.vb calls a code module (in module1.vb) to loop
through the objects on the slide and change various values. Most of it
is fine but on some clides I have to paste values into a datasheet
behind a chart. That works fine if I leave the PowerPoint open and then
manually save and close it. However, as I do several slides I have been
using "opptAPP.save" to close after changing each slide.
I now notice that when I open up the Presentation everything looks ok
until i double-click on a chart at which point the datasheet empties of
any data I pasted into it.
Is there any way to programatically force a "proper" save?
Thanks for any assistance.

john

 

[Steve Rindsberg]

Hi,
I'm writing an application in vb.net (as a bit of a newbie) and need to
automate PowerPoint to add data to slide templates.
My code from the form.vb calls a code module (in module1.vb) to loop
through the objects on the slide and change various values. Most of it
is fine but on some clides I have to paste values into a datasheet
behind a chart. That works fine if I leave the PowerPoint open and then
manually save and close it. However, as I do several slides I have been
using "opptAPP.save" to close after changing each slide.
I now notice that when I open up the Presentation everything looks ok
until i double-click on a chart at which point the datasheet empties of
any data I pasted into it.

Keep in mind that PowerPoint itself doesn't make charts. It calls on an
independent app, MSGraph, to create charts.

I'm guessing you have a handle on that and have been able to automatate it
successfully, but after modifying each graph you need to call the graph
application's .Update method before calling the .Quit method

 

[JzP]

Thanks very much indeed Steve, that's done the job.
The demonstration I have to give will be much less embarrasing now!

John