Reply
 
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

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   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.

--

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
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