Shell to Another Application and Wait Until it Finishes
Author:Intelligent Solutions Inc.
The Visual Basic Shell command does not let you open the shelled-to application synchronously (that is, your program continues to execute while the shelled-to application runs). The code below overcomes this by allowing you to shell to another application and suspend execution of your program until the child application is finished. The optional TimeOutValue parameter allows you to specify the maximum amount of time to wait in seconds before resuming execution of your program.
Instructions: Copy the declarations and code below and paste directly into your VB project.