Populating an OLE object using VB

[Guest]

I need to get data from my Access database into a separate OLE object in
another program (Powerpoint). I want to create and populate an Excel (8) OLE
object that will have data and a graph.
I can get the automation to create the Powerpoint slides, but I can't seem
to get an OLE object to be editted & automatically populate.

Help!

 

[John Nurick]

I'd start by leaving Access out of the equation. Working in Powerpoint,
nut out the VBA code needed to embed a new Excel chart object on a
slide, activate it, and edit it (i.e. fire up Excel under control of the
PowerPoint VBA code). The PowerPoint and Excel newsgroups should be able
to help here.

WHen you've got that working, it should be reasonably simple to
translate the PowerPoint code to run in Access, automating PowerPoint
and Excel both.

 

[Guest]

Thanks John.
I'll be heading to the Excel group soon. The Powerpoint group doesn't have
much VB stuff there.

TF