Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Shell | Excel Discussion (Misc queries) | |||
Shell function II | Excel Programming | |||
Shell function | Excel Programming | |||
Loading PDFs, Shell Function | Excel Programming | |||
use shell function in vbscript | Excel Programming |