I am having a small problem, I run a program (By running VBA's "Shell
cmd) and this program will create a file so I wait for the fil
creation on excel so I can continue working on it.

Now the problem is that there is no telling how long the file will tak
to be created therefore it makes it hard to set a TimeOut on th
program so that after a certain time if no file found stop execution.

What I wondered is, since the "Shell" cmd returns the Task ID, is ther
any function that I can search if a process is running (By the Tas
ID)? Or something similar? This way as soon as the task is not runnin
anymore I can continue the program and if no file was found after tha
I can stop the program without the user having to wait too long or th
program stopping in the middle of the task execution.

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com