This will require some kind of workbook in Excel. You could theoretically
place the code in personal.xls but then you have to assume that your users
have personal.xls. You're probably better off with an addin to hold the code.
The code you need in Excel is something like this:
Sub LaunchYourApp()
Dim RetVal As Variant
RetVal = Shell("YourApp.exe", vbNormalFocus)
End Sub
You can have your program install the addin via ActiveX if you would like. I
can send you some code to do this if you would like. Let me know.
--
Charles Chickering
"A good example is twice the value of good advice."
"ExcelMonkey" wrote:
Is it possible to launch a standalone program from within Excel. That is, I
want to have a .exe - that I have created in VB 2005 - launch based on the
click of an icon or click of a menue item from withing Excel.
The idea being that I have chosen to create the project in a standalone for
and not as an XLA. The question now is how to launch it from Excel or am I
restricted to launching it from outside of Excel?
If its possible I am assuming that I will have to create some logic in my
standalone program which creates the linkages in Excel (i.e. tool bar/menu
items) upon install.
Thanks
EM