Wed 16 May 2007, 18:11Delegate Diane said...
Diane has attended:
No courses
Excel/VBA/Word
I've inserted a command button in my spreadsheet and by clicking it, I want to open a specific word document. I can't find the command to get word to open within the VBA editor.
Thu 24 May 2007, 14:59Trainer Richard said...
RE: Excel/VBA/Word
Hi Diane
As you are unable to add a hyperlink to a command button via Excel, you would need to record yourself opening a specific document in a macro.
An easier way would be to use a graphic of some kind, or text, and then just hyperlink it using INSERT, HYPERLINK from the menu bar.
regards
Richard
