Opening Powerpoint File not working..

[jokobe]

I opened a Word file with this command:
strDocName = strDirName & "\" & file_location
Set WordDoc = WordApp.Documents.Open(strDocName)
Now I'm trying to do the same with Powerpoint:

Set PowerpointDoc = PowerpointApp.Presentations.Open(strDocName)
(of course it is a powerpoint file in this case)

any helpful hints?

jokobe

 

[MikeJohnB]

Take a look at the site below for code to run powerpoint from Access

http://msdn.microsoft.com/en-us/library/aa159920(office.11).aspx

I hope this helps? Does it answer your question, please post again if not

Kindest regards

 

[Daniel Pineault]

If you wish to open a file, any file type, use the FollowHyperlink Method.
It will open the file in question using whichever program that file is
associated with. So for ppt, pps,... it will open using PowerPoint.

Application.FollowHyperlink "FullPath\FileName.ext"

Look it up in the help file for more information if required.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.