Running apps from inside excel
 

Greetings,
Thanks in advance for taking the time to read this ...
With the following code, a powerpoint .pps slideshow will
open, run , close and return to excel, no problem:
Sub RunPowerpointShow()
Dim pwp As Object
Set pwp = CreateObject("PowerPoint.Application")
pwp.Visible = True
Set pwfile = pwp.presentations.Open
(FileName:="P:\test.pps")
pwfile.SlideShowSettings.Run
pwp.Quit
End Sub
I would like to be able to run Lotus ScreenCam files in a
similar manner. These can be created as .exe files which
do not require the user to have any ScreenCam software
installed. Could anyone advise on code required to run
ScreenCam file "P:\test.exe"
TIA
David

Running apps from inside excel
 

in a simple way:

Shell "P:\test.exe"

read up on the Sell command. For more serious work, look
into the VBScript shell object...
Set oShell = CreateObject("WScript.Shell")
With this you can check whether the shell is running etc

Patrick Molloy
Microsoft Excel MVP



-----Original Message-----
Greetings,
Thanks in advance for taking the time to read this ...
With the following code, a powerpoint .pps slideshow
will
open, run , close and return to excel, no problem:
Sub RunPowerpointShow()
Dim pwp As Object
Set pwp = CreateObject("PowerPoint.Application")
pwp.Visible = True
Set pwfile = pwp.presentations.Open
(FileName:="P:\test.pps")
pwfile.SlideShowSettings.Run
pwp.Quit
End Sub
I would like to be able to run Lotus ScreenCam files in
a
similar manner. These can be created as .exe files which
do not require the user to have any ScreenCam software
installed. Could anyone advise on code required to run
ScreenCam file "P:\test.exe"
TIA
David
.