excel to exe

shah.manishkumar.v · 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 · 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.