Hi,
I'm making a simple macro that executes a batch file that creates a text file then the macro uses this text file to import data into a database.
The trouble I'm running into though, is that Access runs the runApp command asynchronously meaning that it doesn't wait until it finishes before moving on to the next action.
So basically what happens is, the next action is executed and then complains because it can't find the file that the runApp action is creating.
Is there anyway to issue a pause in the macro to Wait until the runApp command is finished??
thanks for any help
I'm making a simple macro that executes a batch file that creates a text file then the macro uses this text file to import data into a database.
The trouble I'm running into though, is that Access runs the runApp command asynchronously meaning that it doesn't wait until it finishes before moving on to the next action.
So basically what happens is, the next action is executed and then complains because it can't find the file that the runApp action is creating.
Is there anyway to issue a pause in the macro to Wait until the runApp command is finished??
thanks for any help