Syntax for WshShell.Run to open Powerpoint 2007 in Show mode 1

[willeyc]

Hi everyone
The following only opens Powerpoint application and not the document.
WshShell.Run """C:\Program Files\Microsoft Office\Office12\POWERPNT.EXE""" & "/s" & strFileName,1,True
If I take out the & "/s" the document opens but in Edit mode.

 

[crackoo]

Hi
I think you forgot a sapce after /s
Try this :

'You need to save your presentation as a "Powerpoint Show"
'Open the presentation you want to save as a slide show.
'On the File menu, click Save As.
'In the Save as type list, click PowerPoint Show. Your slide show file will be saved with a .pps file extension.
'When you open this file from your desktop, it will automatically start your presentation in slide show view
Set WshShell = CreateObject("Wscript.Shell")
strFileName = "c:\Document Path\MyDocument.ppsx"
WshShell.Run "POWERPNT.EXE /s" &" "& DblQuote(strFileName),1,false
'**********************************************************************************************
'Function to add double quotes in a variable
Function DblQuote(Str)
	DblQuote = Chr(34) & Str & Chr(34)
End Function
'**********************************************************************************************

 

[willeyc]

Hi crackoo
Thanks for your reply. I like your dblequote function.
Anyway I get "The system cannot find the file specified" on line:
WshShell.Run "POWERPNT.EXT /s" &" "& DblQuote (strFileName) ,1,True

 

[willeyc]

Hi crackoo
I made a stupid typing mistake .EXT instead of .EXE. It now works great, thankyou

 

[PHV]

Why not simply this ?
WshShell.Run DblQuote(strFileName),1,True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886