Running Batch File

[NoiCe]

Hi I really have limited experience with VBA but I am looking for a way to integrate the ability to have access run a Macro and have one of the steps call a .bat file located in a directory that is setup to create a .txt file of that directory's files. The kicker is that the macro needs to wait until the file is completed (CMD window disappears) before moving onto the next steps of the macro. Please see attached sample.

[SoftwareMatters]

Instead of calling a .bat file you could just write the code in vb using the File System Object - do a search for fso and see what comes up. Or check out this link: http://allenbrowne.com/ser-59.html - it may be helpful.
Good luck

[NoiCe]

SoftwareMatters...this is great!!! Thank you!