The use of the SHELL command is as follows.
Code:
Dim dblRetVal as Double
dblRetVal = Shell("C:\MyPath\MyProgram.exe", vbMaximizedFocus)
If it runs OK, dblRetVal is a unique number. If the .EXE fails, dblRetVal is zero and you can do some error trapping. The windows style vbMaximizedFocus is one of a few constants. See help for SHELL to get a complete list.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division