Pause procedure while external app is running.

[Jarryd]

Hi,

Is there a way to make an Access 2003 sub pause while it is executing. I am
launching an Excel file through a .bat file by that is called during the
sub. The Excel file then runs its own macro. I need Access to wait for
Excel and the batch file to terminate before proceeding. Is this possible?
Or is there a better way to call an Excel+Macro file that will wait for it
to finish before continuing?

TIA,

Jarryd

 

[Marshall Barton]

Is there a way to make an Access 2003 sub pause while it is executing. I am
launching an Excel file through a .bat file by that is called during the
sub. The Excel file then runs its own macro. I need Access to wait for
Excel and the batch file to terminate before proceeding. Is this possible?
Or is there a better way to call an Excel+Macro file that will wait for it
to finish before continuing?

Maybe this will help you out:
http://www.mvps.org/access/api/api0004.htm