View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed[_12_] Ed[_12_] is offline
external usenet poster
 
Posts: 2
Default 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


.