Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Shell Jeff Excel Discussion (Misc queries) 0 January 28th 08 04:50 PM
Shell function II Don Guillett[_4_] Excel Programming 1 September 19th 03 03:31 PM
Shell function David Excel Programming 0 September 19th 03 11:30 AM
Loading PDFs, Shell Function Paul Martin Excel Programming 5 July 31st 03 02:52 AM
use shell function in vbscript Sofia Excel Programming 0 July 21st 03 06:29 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"