How can you wait for the SHELL command to terminate ?

[jmoffat]

As the help file points out:

"Note: By default, the Shell function runs other programs
asynchronously. This means that a program started with Shell might not
finish executing before the statements following the Shell function are
executed."

This implies there is a way to cause execution to halt until the shell
command is completed.

Has anyone found a way to do this ?

 

[Dave Peterson]

MS has a solution at:

http://support.microsoft.com/?kbid=214248
XL2000: How to Force Macro Code to Wait for Outside Procedure

Here's a link to a nice ShellAndWait function that does that.
http://groups.google.com/groups?threadm=ump2dlfcBHA.1656@tkmsftngp03

 

[jmoffat]

Thanks a lot Dave - this is exactly what I was looking for.