excel to exe

shah.manishkumar.v · #1 (**permalink**) November 11th, 2011, 03:02 AM

how to excel file into exe ?
my problem is : I want an exe file or msoffice adin in excel file . when one runs the excel file the adin or exe automatically run itself.is if possible to do this?

mtranchi · #2 (**permalink**) November 12th, 2011, 07:07 PM

Use the Shell function in the Workbook_Open event, something like this:

Code:

Option Explicit

Private Sub Workbook_Open()
    Dim RetVal
    RetVal = Shell("C:\WINDOWS\CALC.EXE", vbNormalFocus)    ' Run Calculator.
End Sub

You can find more info on the Shell function in VBA help.

If you're not sure about the Workbook_Open event and where to place it, lemme know.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create excel file without excel.exe	ackid32	VB How-To	15	July 26th, 2013 04:31 AM
exe file in excel	shah.manishkumar.v	Excel VBA	1	November 8th, 2011 07:36 PM
want to run EXCEL.EXE from Visual C++	prashant_dahiya	Visual C++	0	November 3rd, 2006 02:47 AM
Excel.exe error	kliu9	Excel VBA	0	October 26th, 2004 05:21 PM