wait for action to finish before starting next

[blioux]

i have a macro that exports data to a text file
i then use the runapp action to run a .bat ,which is just a command line interface for a program with switches, that modifies this text file
i then want to import this text file back into my database

the problem i'm having is that the macro continues on to the import action before the .bat is finished

any idears?

 

[crosmill]

If the .bat file creates a locking file (like access does when you open a db) you could use the FileSystemObject command to to check for the existance of the file and while it exists loop the macro to check for it.

This could create a lot of problems though, not least locking your computers resources, but you could apply a timer to continue the loop every x seconds or so...Good luck