Problem in VBA for Excel

[Scand]

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

[SteveFlitIII]

You will have to user the WaitforSingleObject API call

[KenX]

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)

[Scand]

Thank you for your help.

Now it works fine.

Thanks again
Scand