Solved

Launch an external exectable in Excel

Posted on 1998-12-17
2
660 Views
Last Modified: 2012-08-13
what is the VBA command to launch an external executable in Excel?
0
Comment
Question by:jdaues
2 Comments
 

Author Comment

by:jdaues
Comment Utility
Edited text of question
0
 
LVL 1

Accepted Solution

by:
ajwnet earned 50 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now