Do you want Excel to open a program or a spreadsheet? here's what I use to open spreadsheets.
Sub Macro1()
'Keyboard Shortcut: Ctrl+t
Workbooks.Open FileName:="C:\My Documents\FileName.xls"
End Sub
I just assign a shortcut to it, in this case Ctrl+t.
I've never opened a "Program" within excel but I think if you replace the "Filename.xls" with your program name, it should work. Good Luck
P.S. If there's a better way, let me know.
QUOTE OF THE DAY
I'm a firm believer in the theory that people only do their best at things they truly enjoy.
Kinda works. I get a gread opening of the file this way. Tho there is this problem, it opens the program code in a excel sheet.....not quite what i need, help please!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.