HELP! I need to pause a macro while a batch file runs

[smartin]

I am trying to make a macro in Access pause while a rename
a file using a batch file. It takes approx a second but
access goes to the next line on the macro after calling
the command. I need it to either wait for the batch file
to stop or wait 1/2 a second...

Any ideas???

 

[John Nurick]

In VBA you can use the "shell-and-wait" code here:
http://www.mvps.org/access/api/api0004.htm

I am trying to make a macro in Access pause while a rename
a file using a batch file. It takes approx a second but
access goes to the next line on the macro after calling
the command. I need it to either wait for the batch file
to stop or wait 1/2 a second...

Any ideas???

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.