The MSDN has an articles that describe how to launch a program using Shell
and then wait for it to complete.
Search the MSDN (http://msdn.microsoft.com/vbasic/) looking for articles:
Q171127 or Q212547 for
VBA Q96844 or Q129796 for VB 16/32 bit
Quote:
> I use the "shell" command to launch a scientific DOS program. This one
> creates different files, and I have to use its in the same sub when my
> program is finished. The problem is that the sub and the program continue
to
> run in the same time so I can't exploit my files in the sub. So, how can I
> make the sub waiting for my program results ?
> Actually I use error management with a loop around an "open" command but
it
> strongly decreases my program speed...