Hello
Does anyone knows how to create a command button or hyperlink to open another application from Excel 2003
Thanks

You need to attach a macro like this to the button :-

'-------------------------------------------------
Sub OpenCalc()
ReturnValue = Shell("CALC.EXE", 1)
End Sub
'------------------------------------------------

--
Message posted from http://www.ExcelForum.com

-----Original Message-----
Hello,
Does anyone knows how to create a command button or
hyperlink to open another application from Excel 2003?
Thanks
.


hello hutchuse007,

here are the steps in making a button and making a link
using a button to open up other application from excel

Making a button
1. go to view,toolbars, click on forms
2. a small window will open up, point your mouse to it
until you will see it say button
3. click on it
4. then go to excel click on your mouse and hold on it,
then drag it until you make a button
5. Name your button

Button To Link to excel application

6. this step continue from step 5
7. look on the left you will see "Record"
8. click on it
9. a window pop up, then click on OK
10 you will see a small window that will recored your
button
11. go to the file you have on excel that you want to
open it up when you click on the button. Let say for
example u have a file call abc.xls under c:\budget\abc.xls

so go to file, open,budget,abc.xls , double click on
abc.xls

12. on step 10 there was a small window that open up
find that window and click on stop to stop recording
13. now click on your button it should open up your file
14. to double check on it, go to tools,macro, click on
macros, then look for the name that you name your button,
high light it and then click on edit, you should see
something like this

Workbooks.Open Filename:="C:\budget\abc.xls"

hope this will help you :)
khamphout vincent au