VBA code to run & wait for cmd line interface application

[David]

I want to get started with the shell command to run my process below under 1
VBA subroutine. I've just started looking at methods to wait for the external
application to complete. Any pointers would be very welcome.
Thanks
Here are the broad steps in my current process:
Excel sub1
get list of external app1 filenames from directory1 according to inputbox
transcribe files in list from .txt1 to .txt2 structure
write command file com.txt for external app2 to run with .txt2 files as input
end sub
Command line
MyBatch.bat
run external app2.exe<com.txt (output is .txt3 files)
exit Batch file
Excel sub2
read & process .txt3 files
update worksheet database
end sub

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/ShellAndWait.htm