MrExcel Publishing
Your One Stop for Excel Tips & Solutions

launching an external application from excel


Posted by Jason Davis on September 20, 2001 7:37 AM

I have a data acquisition system which I would like to be able to launch from Excel. How do I get the application to start from a macro or VB?


Posted by Mark O'Brien on September 20, 2001 9:54 AM

Here's an example that launches Calculator:


' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.

Posted by Jason Davis on September 20, 2001 12:58 PM

Thank you for the responce, it works fine.
I did make one change to load the user application within the program.

: I have a data acquisition system which I would like to be able to launch from Excel. How do I get the application to start from a macro or VB?