Possible to automate Powerpoint from within Excel or Visual Basic?

G

Greg_Del_Pilar

Hi!

I have written a VBA macro in my Powerpoint file. I want to be able to have
Excel (or a Visual Basic standalone program) to load Powerpoint and
automatically run this macro. Does anyone know if this is doable? I tried
recording my keystrokes into an Excel macro, but the farthest I was able to
get was to activate Powerpoint.

Thanks for your help.

Greg
 
I

Immanuel

In XL, you can create a PPT Application object using:

Dim oPPTApp
Set oPPTApp = Application.CreateObject("PowerPoint.Application")

/i.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top