G'day,
How does one know when an MS Access Macro has completed-?
To start a macro is as follows:
http://www.mjtnet.com/usergroup/viewtop ... &view=next
However, if for example I'm exporting a table to EXCEL file - I need to know when the export is completed before:
- KillProcess>MSACCESS.EXE
and
- moving on with the next step of the Macro Scheduler
Cheers & thanx
MS Access -How does one know when macro has terminated
Moderators: JRL, Dorian (MJT support)
A couple of methods I've used.
1) Make the last line of the Access Macro Quit/Exit Access then have Macro Scheduler wait for Window "Access*" to close
2) If you don't want to close Access, make the last line of the Access Macro a message box, then have Macro Scheduler wait for a window with the message box name to open.
1) Make the last line of the Access Macro Quit/Exit Access then have Macro Scheduler wait for Window "Access*" to close
2) If you don't want to close Access, make the last line of the Access Macro a message box, then have Macro Scheduler wait for a window with the message box name to open.
