View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Edwin Kelly Edwin Kelly is offline
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