Try using a timer control to check for the file on regular intervals until
it is done, at which time you can get it and continue processing. You will
probably want to use DoEvents with this to give the user a little more
control.

Bill Barclift

"daver676" wrote in message
...
Hello.

I'm looking for a way to pause the execution of a macro
until another task (a batch file) is finished running.
Could someone help me out, or maybe point me in the right
direction? I'm pretty new to VBA, so be gentle....

Thanks

Dave