wait for action to finish before starting next (1 Viewer)

[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

is my answer with vba?

any help would be greatly appriciated

 

[Rich]

I think DoEvents is what you're looking for

 

[blioux]

I'm not really familiar with doevents does anyone have any code examples?

thanx in advance!