Hi Nook
There may be a solution using API functions.
Do a Google search for API Functions.

HTH
Cordially
Pascal


"NooK " a écrit dans le message de
...
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 file
creation on excel so I can continue working on it.

Now the problem is that there is no telling how long the file will take
to be created therefore it makes it hard to set a TimeOut on the
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 there
any function that I can search if a process is running (By the Task
ID)? Or something similar? This way as soon as the task is not running
anymore I can continue the program and if no file was found after that
I can stop the program without the user having to wait too long or the
program stopping in the middle of the task execution.

Best Regards

NooK


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

Nook
In addition have a look at
www.allapi.net

HTH
Cordially
Pascal

"papou" a écrit dans le message de
...
Hi Nook
There may be a solution using API functions.
Do a Google search for API Functions.

HTH
Cordially
Pascal


"NooK " a écrit dans le message de
...
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 file
creation on excel so I can continue working on it.

Now the problem is that there is no telling how long the file will take
to be created therefore it makes it hard to set a TimeOut on the
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 there
any function that I can search if a process is running (By the Task
ID)? Or something similar? This way as soon as the task is not running
anymore I can continue the program and if no file was found after that
I can stop the program without the user having to wait too long or the
program stopping in the middle of the task execution.

Best Regards

NooK


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