We are trying to automate, via Scheduled Tasks, the starting of Excel and Access. The Excel workbook contains a macro that runs when the workbook is opened. It downloads data, formats it and saves it in a folder as text. When finished, Excel shuts down. We have this much working.

We now want to start Access and open a particular database. When Access starts, a macro should start automatically that imports the text data created by the previously run Excel workbook. Access should then shut down.

What is the best way to do this via scheduled tasks so that Access does not start before the Excel program finishes?

Thanks.