How do I specify the powerpoint.application version in VBA?

[Johnny C]

I've got some code chucking reports from XL2007 into a powerpoint presentation.

The PC default powerpoint is Powerpoint 97, but there's also powerpoint 2007. I can't change the default to the later one because it's on XP clamped down, I can't access useful things like changing default programs for file-types.

So, when I do

Dim PPApp As PowerPoint.Application

If PPApp Is Nothing Then Set PPApp = New PowerPoint.Application

it opens Powerpoint97.

I know you can specify the version to open, but VBA Help just says you can, it doesn't mention anything useful like how to do that.

How do I specify the PP version?

TIA

 

[Johnny C]

Sounds like a lot of bother then... easier to pop up a dialog saying 'Open PP 2007 before continuing'

 

[RoryA]

It's not so bad if you are opening a specific file, since you can then use GetObject to grab a reference to it.

 

[Johnny C]

true.

Unfortunately for creating new presentations I don't know where my PP07 application is, as I can't see my C drive. I can probably guess but you never know in this place.

I could create a 'new' doc in PP07 by opening a blank .pptx saved in a particular location, and just make sure it's saved to a new name.