Open correct version of Powerpoint with VBA

[kev_]

I have both Office 2010 and Office 2016 on my PC
When I double-click on a file name it always opens the file with PowerPoint 2016 ( this is what I want)

But I also want to open a presentation from Excel using VBA
I use the code below which works BUT the file is opened in Powerpoint 2010 - ( I want it to open with PowerPoint 2016)

Please Login or Register  to view this content.

So what needs to be changed make VBA open the file in PowerPoint 2016?

thanks

[cytop]

The PowerPoint Reference in the Tools/References menu... You need PP 16, it probably references PP14

[Keebellah]

Hi, if always want to open Powerpoint 2016 you can do that in Windows explorer, search of a pp file and right click open with and choose 2016 and set it to always use 2016.
If not, you will have to code both paths to Powerpoint:

C:\Program Files (x86)\Microsoft Office\Office14\POWERPNT.EXE
or
C:\Program Files (x86)\Microsoft Office\Office16\POWERPNT.EXE

In my case it's 32-bit Office ; C:\Program Files\.... with 64-bit Office

[kev_]

@cytop - thanks for suggestion but that's not the problem

pp16.jpg

[Keebellah]

Try my idea

[cytop]

So much for VBA updating references to the latest version automatically...

Would be interested myself to know what happens if you use Late Binding rather than Early Binding.

Please Login or Register  to view this content.

[kev_]

@cytop - it returns 14.0
which you expected

[humdingaling]

https://stackoverflow.com/questions/...-2010-in-excel

same concept but with word
try method mentioned by SeanC

[kev_]

@Keebellah thanks for your suggestion

Hi, if always want to open Powerpoint 2016 you can do that in Windows explorer, search of a pp file and right click open with and choose 2016 and set it to always use 2016.

This has already been done that is why clicking on files automatically opens in PowerPoint2016

How do I incorporate your other suggestion into my code?

C:\Program Files (x86)\Microsoft Office\Office16\POWERPNT.EXE

For some reason, my path is C:\Program Files (x86)\Microsoft Office\root\Office16

[Keebellah]

The VBA code you show means that one version is already opened.
What you need is like a vbs script that gives you the choice BEFORE any version or PowerPoint is opened.

[Keebellah]

If you take a look here (it's for Excel) you will get the idea
link removed

[AliGW]

Please don't link to other Excel forums. Give the required information here within the thread. Thanks!

[Keebellah]

I do not think it's a good idea to paste the entire post content.
What's the problem with a link?

[AliGW]

Rule #13a. Please post the relevant code here. Thanks.

[cebalaw]

What about using the Shell command to open the file in PowerPoint, then set your PowerPoint object?

For my machine, this is where PP is located:

Please Login or Register  to view this content.

[kev_]

The correct version of PowerPoint opens if code begins with this line:

Please Login or Register  to view this content.

What do I need to add in my Excel macro for it to open D:\Documents\myPresentation.pptm and set the opened presentation to variable PPpres?

[kev_]

thanks @cebalaw - we were typing at the same time - I will try your suggestion

[cebalaw]

Is that not what I just wrote?
It didn't work for you?

[Keebellah]

That's the idea, but with a vbs script you can inlude an msgbox asking which version and depending of that you can replace the 16 with 14 or 12 depending on the version you're using.

[kev_]

@cebalaw THANKS This method did indeed work

Please Login or Register  to view this content.

[kev_]

Ok
Post#20 method has kept me going
- but is a workaround that will cause problems if I share the file with anybody else

Anyone know a permanent fix to default VBA to open PowerPoint in 2016 version?
- could this be a Registry issue?

[cebalaw]

If you are concerned about different locations for PowerPoint application, could you not just test for the existence of the POWERPNT.EXE file in each directory (in order: 64-bit, then 32-bit) using DIR()?

Please Login or Register  to view this content.

[cebalaw]

Back to the cytop message #6

Would be interested myself to know what happens if you use Late Binding rather than Early Binding.

Did you try to include the version you want (16)?

Please Login or Register  to view this content.

As far as the registry, what do you have under HKEY_CLASSES_ROOT\PowerPoint.Application\CurVer?

[kev_]

Did you try to include the version you want (16)?

Yes - returns value 14 (which is 2010)

[kev_]

@cebelaw

As far as the registry, what do you have under HKEY_CLASSES_ROOT\PowerPoint.Application\CurVer?

This - which looks correct

regEdit.jpg

[xlnitwit]

The CLSID is the same for every version of a given Office product, which is why passing a version number to CreateObject has no effect. Shell and then GetObject is the only method I have ever seen working. Do many of your users have multiple Office versions installed?

[kev_]

@xlnitwit - Thanks for that info - useful to know why that did not work

Most other users are single version PC's and so this code would work for them

Please Login or Register  to view this content.

I use 2016 99% of the time and so would prefer this to be the VBA default (why should I be different? )
- I am a simple soul and (although I do not understand what is going on "behind the scenes") hope there must be a "secret" value (somewhere) that can be changed
- otherwise I have to live with this until I ditch 2010

I only open 2010 when testing for backwards compatability
- I would prefer to use the shell command for 2010