-
I have a little problem in VBA for Excel.
I have started a DOS-Application via Shell and now i want to wait, till the started application is finished. How Can i do this?
In VBA for Word it have a Tasks.Exists function. Does it have a similar function in VBA for Excel? When not, how can i do this with other functions?
Thanks
Scand
-
You will have to user the WaitforSingleObject API call
-
use the API:
Declare Function GetModuleUsage% Lib "kernel" (ByVal hModule%)
or you might want to see the tips
"How do I tell when an app executed using SHELL is finished?"
(http://www.vb-world.net/tips/tip5.html)
and/or
"Knowing when an app has finished the shell command"
(http://www.vbsquare.com/tips/tip280.html)
-
Thanks
Thank you for your help.
Now it works fine.
Thanks again
Scand