Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can you wait for the SHELL command to terminate ?
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?thre...%40tkmsftngp03 jmoffat wrote: 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 ? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can you wait for the SHELL command to terminate ?
Thanks a lot Dave - this is exactly what I was looking for.
------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use the "shell" command? | Excel Discussion (Misc queries) | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
terminate a form | Excel Discussion (Misc queries) | |||
Copying a file with VBA (or with a SHELL command) | Excel Programming | |||
Can't terminate the excel instance from VB | Excel Programming |