Know when .cmd has finished

If you're lucky and you know that your .cmd file always takes less than x
seconds, you could add application.wait (x + 30% seconds)
(or whatever you feel comfortable with.)

But there are other ways.

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

Here's a link to a nice ShellAndWait function that does that.
http://groups.google.com/groups?thre...%40tkmsftngp03

krayten wrote:
>
> Hi folks,
>
> I have a little macros which at one point shells a .cmd file to run
> minimised, almost
> in the background as it were.
>
> Shell "C:\Hotfixer\customscan.cmd", 2
>
> The trouble is I don't want the user moving on into the next phase of
> event handling until that
> .cmd has completed what it needed to do. The user could end up querying
> for data that the
> .cmd hasn't yet returned.
>
> What I want to do is have a "please wait" then a "OK Data retrieved"
> kind of sequence
> which starts when the shell spawns and the finishes when the .cmd
> expires.
>
> I'd be very grateful indeed for any advice or sample code.
>
> I am very new to xlvba so the simpler it could be the better!!!
>
> Many thanks,
>
> ========
> Stuart

--

Dave Peterson

Dave,

That's ideal. I'll check out all these suggestions.
Thanks for the superswift response!!

Best regards,

Stuart