Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 673
  • Last Modified:

Launch an external exectable in Excel

what is the VBA command to launch an external executable in Excel?
0
jdaues
Asked:
jdaues
1 Solution
 
jdauesAuthor Commented:
Edited text of question
0
 
ajwnetCommented:
Hi. Here's how to open the calculator for example, using the Shell function..
'------------------------------------------------------------
Sub Macro1()
' Macro1 Macro
' Macro recorded 17-12-98 by Andy Walters
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)    ' Run Calculator.
End Sub
'------------------------------------------------------------
'nb. Specifying 1 as the second argument opens the application 'in normal size and gives it the focus.

0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now