Shell function II
 

This MSKB article shows the use of CreateProcess to deal with this
type of situation.

http://support.microsoft.com/support.../q209/8/76.asp

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Fri, 19 Sep 2003 06:02:07 -0700, "David"
wrote:

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
 

David,

You could you the FreeFile function to get the file
number, then use the Close Statement.

-----Original Message-----
This MSKB article shows the use of CreateProcess to deal
with this
type of situation.

http://support.microsoft.com/support...icles/q209/8/7
6.asp

HTH
Paul
---------------------------------------------------------
-----------------------------------------------------
Be advised to back up your WorkBook before attempting to
make changes.
---------------------------------------------------------
-----------------------------------------------------
On Fri, 19 Sep 2003 06:02:07 -0700, "David"

wrote:

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

.