How to write VBA to call a PPS file?

[cheer]

Anyone familiar to writeVBA to call a PPS file?

 

[RuralGuy]

Have you tried using the shell() command? Windows will find Power Point for you.

 

[vbaInet]

Application.FollowHyperlink() should work also.

 

[cheer]

Have you tried using the shell() command? Windows will find Power Point for you.

I got the answer. TQ

On Error GoTo errHandler
Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL \\xxxx\yyyy\abc.pps"
Exit Sub
errHandler:
ErrMessage Err.Description

 

[RuralGuy]

I would think you could have just said:
Shell "\\xxxx\yyyy\abc.pps"
...and it would have worked.

 

[cheer]

I would think you could have just said:
Shell "\\xxxx\yyyy\abc.pps"
...and it would have worked.

I try this, it doesn't work. I think it should come together with another method call AppActivate. Correct me if I'm wrong.

 

[cheer]

On Error GoTo errHandler
Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL \\xxxx\yyyy\abc.pps"
Exit Sub
errHandler:
ErrMessage Err.Description

Earlier I hv mentioned above code, any idea how to open a PDF file in a MAXIMIZE mode by using same way ?

 

[speakers_86]

Look into the Windows API ShellExecute. Here is a kb article on it. You would be interested in the last parameter MS calls FsShowCmd.

 

[cheer]

Look into the Windows API ShellExecute. Here is a kb article on it. You would be interested in the last parameter MS calls FsShowCmd.

Thanks for the above clue. I got a better explanation through this link