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