Open Word Doc From Excel Macro

[Guest]

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?

 

[Guest]

One way

http://support.microsoft.com/kb/q177760/


Regards,

Peo Sjoblom

 

[Chuck Davis]

-----Original Message-----
One way

http://support.microsoft.com/kb/q177760/


Regards,

Peo Sjoblom


.

Note that the link provided by Peo is applicable to Office 97.

 

[Dave Peterson]

It looks like it should run in any version of excel/word, though.

 

[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"