Shell to another app and wait for it to finish using Windows Scripting Host

Category:
Miscellaneous
Type:
Snippets
Difficulty:
Intermediate
Author:
Gary K

Version Compatibility:

More information:
MUST HAVE Windows Scripting Host installed in a computer in order to use this routine

Set Reference to "Windows Scripting Host Object Model (Ver 1.0)" wshom.ocx

Declared constant explanation:

0 - Hides the window and activates another window.
1 - Activates and displays a window. If the window is minimized or maximized, the system restores it to its original size and position. An application should specify this flag when displaying the window for the first time.
2 - Activates the window and displays it as a minimized window.
3 - Activates the window and displays it as a maximized window.
4 - Displays a window in its most recent size and position. The active window remains active.
5 - Activates the window and displays it in its current size and position.
6 - Minimizes the specified window and activates the next top-level window in the Z order.
7 - Displays the window as a minimized window. The active window remains active.
8 - Displays the window in its current state. The active window remains active.
9 - Activates and displays the window. If the window is minimized or maximized, the system restores it to its original size and position. An application should specify this flag when restoring a minimized window.
10 - Sets the show state based on the state of the program that started the application.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: