LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 03, 02:36 PM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Jul 2003
Posts: 2,337
Default Shell function II


"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

  #2   Report Post  
Old September 19th 03, 03:31 PM posted to microsoft.public.excel.programming
jaf jaf is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2007
Posts: 300
Default 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.



johnf202 at hotmail dot com

"David" wrote in message
Yes, 'manualy' had occured to me...
Can it be closed from the Excel VBA code?
Thanks again

-----Original Message-----

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 05:50 PM
Shell function David Excel Programming 0 September 19th 03 11:30 AM
Shell Statement [email protected] Excel Programming 1 August 13th 03 08:19 PM
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 12:09 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017