Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA For Power Point

Status
Not open for further replies.

puforee

Technical User
Oct 6, 2006
741
US
I have several Power Point (PP) files that I show from a WEB site. PP 2010 and IE 8. All though the PP files are saved as .ppsx file's, presentations..they do NOT open as a presentation. They open in the .pptx view. This is a know issue. I know Excel and Access can have code attached to select functionality when the file is open. Dose VBA in PP also allow code that would allow me to force it to open in the .ppsx format. Like and auto start? Could someone point me to some code that may help?

Thanks,

 
Hi,

.ppsx is a PowerPoint show; .ppsm for a show with code.

A PowerPoint presentation is either a .pptx or pptm if you have VBA code.

Have you educated yourself on the difference?
 
OK...I guess I did not explain it well. I have a ppsx that is being opened from a WEB link. However it does not open as a show. It opens more like a pptx...showing the slides on the right...it is set to read only.

This is a known issue with ppsx files and Office 2007 or above.

I just wanted to know if I could put VB in the PowerPoint so it will force the show to start when it is opened...from a WEB link. Google says No Can Do. Unlike Excel and others there is not an Autoexc process that will run when a Power Point file opens.

The only suggestion I have seen is to create an Add-In that runs the show.....because the add-in must be loaded everythime the Power Point opens...it would start the show. The problem is, where does the add-in reside if it has to be loaded everytime Power Point starts?

Anyone familiar with this process?
 
As it says here:
the way a browser opens links to PPT or PPS or the newer PowerPoint 2007 PPTX/PPSX and other files depends on local user settings and/or settings on the web server. It's not necessarily something you as the web page/presentation author can control.
...
In order for links to PPTX/PPSX files to work, two conditions must be met:
•The user must have PowerPoint 2007, the 2007 Viewer or an older version of PowerPoint with the compatibility pack installed so that they can open PPTX/PPSX files in the first place
•The web server configuration on your site must have the correct mediatype/MIME settings to serve PPTX/PPSX files as PowerPoint 2007 presentations.
As you can see, the 'known issue' is not limited to "ppsx files and Office 2007 or above" and much depends on proper web site configuration. Adding a macro to the presentation file will only add a whole new set of security issues for your users, who might quite reasonably have an aversion to allowing macros in presentations downloaded from a web site to run. And no, you can't enforce the running of the macro.

Cheers
Paul Edstein
[MS MVP - Word]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top