If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: 2nd macro action starts before 1st macro is done

Hi,

These are the sequential steps of my Access macro actions:
1. My Access 1st macro is RunApplication to open up an Excelfile called "template.xls" to perform complicated task.
2. template.xls auto-start and completed the data population and export to Access table named "WeeklyServiceLevelData"
3. Access 2nd macro then run some other tasks base on the table "WeeklyServiceLevelData"'.

My problem is that the Access 2nd macro kicks in even before the template.xls has finished its job exporting the updated data to Acc table (ie. the 2nd macro is processing the wrong data base on the previous week's table "WeeklyServiceLevelData" that still resides).
How do I solve this ?

Any of your help here is much appreciated.
Big THANKS to you in advance.