Hi all,
I have automated an excel workbook to copy various ranges and charts to a powerpoint template.
This works great on my pc using Excel 2007 & powerpoint 2003
Now a colleague is running this report. They also have Excel 2007 & powerpoint 2003. Although as they are on a thick client on a server, when they run the code it opens powerpoint 2010.
It would appear at somepoint the machine had 2010 installed, then uninstalled but there is a reference somewhere that opens ppt docs using the 2010 version installed on the server.
So my plan was to write some code to open 2003 PP if its available, otherwise use the default version.
Reason being is that when it opens the template on 2010 and copies the charts from excel as enhanced metafiles it changes the colours.
If the user opens PP 2003 before running the code it opens the template in 2003 and all the colours are fine.
Below is the code I have come up with.
It all works fine except when it opens the 2003 version using the shell command, it takes a while to get the object. So it sits open with a new presentation before updating the slide.
So I set the Shell command to VBHide but then need to unhide it when the slide is updated.
It has taken me ages to find this information to get it to work.
Has anyone got any better solutions?
Note: my code is currently opening 2007 version as I am using this on my home pc and don't have 2003 installed
Bookmarks