G
Guest
Hi
I'm trying to piece together a macro which will invoke an external command but wait for it finish before invoking several queries. My current macro has a RunApp statement that invokes a command to create a data file. It also has several queries that then import that data. My problem is that as soon as the external command is invoked, the macro continues running through the queries. The queries finish before the data file exists
Is there a way I can ask the macro to pause until the external command finishes
Any help is greatly appreciated
Cheers
Shannon
I'm trying to piece together a macro which will invoke an external command but wait for it finish before invoking several queries. My current macro has a RunApp statement that invokes a command to create a data file. It also has several queries that then import that data. My problem is that as soon as the external command is invoked, the macro continues running through the queries. The queries finish before the data file exists
Is there a way I can ask the macro to pause until the external command finishes
Any help is greatly appreciated
Cheers
Shannon