Open Word Doc From Excel Macro

M

MATT

I have an Excel Sheet that contains Macros. At the end of one of the Macros,
I would like it to open a Word Document. Something like Document.open
FileName:="C:\Path\name.doc", except it needs to run from the Excel sheet.
Is there a way to do this?
 
D

Dave Peterson

If you're not trying to control word from excel, you could just start your
document:

Shell "Start ""c:\path\name.doc"""

(just add that line into your code.)

You could even use a hyperlink (placed on the worksheet or started in code):

ActiveWorkbook.FollowHyperlink Address:="c:\path\name.doc"
 
Top