Open Word Doc From Excel Macro
 

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?

One way

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


Regards,

Peo Sjoblom

"MATT" wrote:

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?

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

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


Regards,

Peo Sjoblom

"MATT" wrote:

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?
.

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

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



Chuck Davis wrote:

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

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


Regards,

Peo Sjoblom

"MATT" wrote:

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?
.

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

--

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"



MATT wrote:

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?

--

Dave Peterson