Trying to open a powerpoint presentation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jokobe - 15 Jul 2007 12:58 GMT

I'm trying to open an powerpoint presentation with this code:
Set PowerpointApp = GetObject("& strDocName &")
pr.SlideShowSettings.Run
the strdocname holds the filename and the value is set a few lines before.
But the PowerpointApp is always "nothing" and no file is opening.

Any helpful hint?

jokobe

Reply to this Message

Douglas J. Steele - 15 Jul 2007 13:17 GMT

Try:

Set PowerpointApp = GetObject("""" & strDocName & """")

or

Set PowerpointApp = GetObject(Chr$(34) & strDocName & Chr$(34))

What you've got is telling Access to open a presentation named, literally,
"& strDocName &", which isn't what you want.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> I'm trying to open an powerpoint presentation with this code:
> Set PowerpointApp = GetObject("& strDocName &")
[quoted text clipped - 5 lines]
>
> jokobe

Reply to this Message