Excel VBA to act on PowerPoint file that is already open?

[gregersdk]

Hello good VBA people!

I have some VBA code in Excel that acts on PowerPoint, which is nce. However, I have always opened the PowerPoint file from the VBA code.

I would like to make a more general toolbox, where I use Excel macros to to change something in an open PowerPoint file. The question is, how do I refer to a PowerPoint file that is already open and?

The refrase, I would like to have a general pptx file open, then be able to run an Excel based macro on it, without having to specify the file other than having it open in the background. I have tried to search around for this, but all examples found involved making new pptx files, which is not what I want.

Anybody has any idea?


GregersDK

[WideBoyDixon]

Assuming that you've previously been using CreateObject to create a new PowerPoint application/presentation, you can switch to using GetObject something like this:

Please Login or Register  to view this content.

WBD

[gregersdk]

Oh man, I thought it would be something simple... It's one of those things that are difficult to Google if you don't already know the right expression I guess...

Thank you very much!