Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to Determine if Application Window Still Active

I am launching a CMD window with the Shell command and running a command that
I am building in code. I want to be able to determine if the window is still
active before proceeding. Is there a way to do that?
--
Edwin Kelly
Houston, TX
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default How to Determine if Application Window Still Active

Shell and wait may do what you require.

http://www.cpearson.com/excel/ShellAndWait.htm

Mike

"Edwin Kelly" wrote:

I am launching a CMD window with the Shell command and running a command that
I am building in code. I want to be able to determine if the window is still
active before proceeding. Is there a way to do that?
--
Edwin Kelly
Houston, TX

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to Determine if Application Window Still Active

I've implemented a Pause of 10 seconds but many times the window only runs
for a split second and other times it runs much longer. I need to be able to
determine exactly when the window closes to prevent too many windows being
created.
I can capture the number assigned to the window being created but I do not
know how to use that with other Windows commands to test if it is still
open/active.
--
Edwin Kelly
Houston, TX


"Mike H" wrote:

Shell and wait may do what you require.

http://www.cpearson.com/excel/ShellAndWait.htm

Mike

"Edwin Kelly" wrote:

I am launching a CMD window with the Shell command and running a command that
I am building in code. I want to be able to determine if the window is still
active before proceeding. Is there a way to do that?
--
Edwin Kelly
Houston, TX

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to Determine if Application Window Still Active

Sorry I did not notice the link in your posting. Will take a look and try it
out. Thanks !
--
Edwin Kelly
Houston, TX


"Mike H" wrote:

Shell and wait may do what you require.

http://www.cpearson.com/excel/ShellAndWait.htm

Mike

"Edwin Kelly" wrote:

I am launching a CMD window with the Shell command and running a command that
I am building in code. I want to be able to determine if the window is still
active before proceeding. Is there a way to do that?
--
Edwin Kelly
Houston, TX

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
VBA: Make Excel the active application Gaetan Excel Discussion (Misc queries) 0 March 19th 07 05:57 PM
Active Window Question CWillis Excel Discussion (Misc queries) 4 July 19th 06 05:52 PM
How do I open a new window for each excel application? Kris New Users to Excel 2 February 21st 06 09:59 PM
How to set Excel to open a new window for each application Luke Excel Discussion (Misc queries) 1 September 28th 05 11:50 PM
How do I set up Excel to open a new instance/application window w. DK9144 Excel Discussion (Misc queries) 1 February 21st 05 04:34 PM


All times are GMT +1. The time now is 04:08 PM.

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"