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

  • Thread starter Thread starter smartin
  • Start date Start date
S

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???
 
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???
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top