Hello,
I have both Office 2003 and Office 2010 installed on my Windows Vista System as different features are needed from each.
The problem is that my macro in Excel 2010 opens PowerPoint 2003 and I can't figure out a way to get it to open PowerPoint 2010.
I'm using this code:
Code:
I have added the reference: Microsoft PowerPoint 14.0 Object Library.
Please Login or Register to view this content.
Thank you in advance.
ML
Last edited by mlexcelhelpforum; 06-16-2011 at 09:01 AM.
Try
orPlease Login or Register to view this content.
Or you can move the reference to the top of the list of references.Please Login or Register to view this content.
Last edited by snb; 06-16-2011 at 05:35 AM.
Dear snb,
Thanks for your response.
I tried both codes, but both still opened an Office 2003 PowerPoint presentation rather than an Office 2010 PowerPoint presentation.
I don't know if it helps to show more of the code:
Of course the code fails when it gets to the part where it must open the specific file, because it has launched the PowerPoint 2003 application and cannot open a .pptx file.Please Login or Register to view this content.
I'm wondering if the problem could somehow be because I have the click-to-run version of Office 2010 installed?
ML
I also tried moving the reference up as far as it would go on the list, but PowerPoint 2003 was still opened instead of 2010.
Another new clue:
If I open PowerPoint 2010 before running the macro, the macro works. So when PowerPoint 2010 is not open, it defaults to opening 2003. Any idea what to do there?
What happens if you use:
Please Login or Register to view this content.
If I do that, again PowerPoint 2003 tries to open the file, but a message box says:
This file was created by a newer version of Microsoft PowerPoint. Do you want to download a compatibility pack so that you can work with this file.
Hi,
You can download the MS Office compatability pack which will allow you to open 2007/2010 files in earlier verions.
As far as automating Powerpoint goes, CreateObject() etc will open the most recently installed version of Powerpoint. However, the click-to-run office operates in a virtual environment and the results of a quick online search suggested that it does not support automation. The suggested workaround is to convert to an MSI installation.
Thanks, Colin.
I'm not interested in downloading a compatibility pack to open my 2010 .pptx file with PowerPoint 2003. As I have PowerPoint 2010 installed on my machine, I'd like to open the presentation with 2010.
For now I'm going to use my workaround which is to first open PowerPoint 2010 before running the macro, and as soon as I get the code to work, I'll see about switching to the MSI installation.
In the MSI installation is the program installed under C instead of a virtual drive?
Thanks to both of you for your tips.
ML
I think it has to do with the map options: the link that is laid between a file extension and the program that has to be activated when opening such a file.
If I double click a PowerPoint 2010 file on my desktop, PowerPoint 2010 opens it.
If I double click a PowerPoint 2003 file on my desktop, PowerPoint 2003 opens it.
It's only when I try to open PowerPoint 2010 from an excel macro that PowerPoint 2003 opens instead of 2010.
Unfortunately I don't know a thing about map options, yet. Are map options something I could and should edit?
Thanks,
ML
What happens in Excel 2010 when using:
Please Login or Register to view this content.
Snb,
I just gave it a try. I don't want to speak too soon, but it looks like... that worked!
Hopefully when I go back and try that again, it doesn't stop working.
How did you figure that out?!
AMAZING!
ML
How do we mark this as SOLVED?
Click in the link in my signature to see how it's done.
Oops, didn't notice that before! Done.
Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks