Shell function II
 

manulaly.

"David" wrote in message
...
My earlier attempt at this question needed clarifying:
Help with the following will be much appreciated:
Sub RunIntro()
Dim SCamShow
SCamShow = Shell("C:\ScreenCams\Intro.exe", 1)
End Sub
This sub runs fine, however, ...
Intro.exe is a Lotus ScrenCam stand alone movie. The movie
file contains the 'Lotus ScreenCam Player' application.
When the movie runs and finishes, the 'Player' application
is left open and remains visible in the form of a 'run
movie' control above excel.
How do I close the 'Player' application within the VBA
code?
David

Shell function II
 

Hi David,
Try it this way.

Shell Environ("comspec") & " /c C:\ScreenCams\Intro.exe", vbNormalFocus

Use /c to close the window when done, /k to keep it open.

--

John

johnf202 at hotmail dot com


"David" wrote in message
...
Don,
Yes, 'manualy' had occured to me...
Can it be closed from the Excel VBA code?
Thanks again
Daid


-----Original Message-----
manulaly.