I am trying to open a specific word doc from xls
I have searched the forum and all word related threads are more complicated, I imagine that this would only require a fex lines ?
I am trying to open a specific word doc from xls
I have searched the forum and all word related threads are more complicated, I imagine that this would only require a fex lines ?
Greetings Neodubois,
Is the word document in the same folder as the workbook? Not a big deal whether yes or no, just would like any respondant to be able to provide the best answer first time out.
Mark
If all you want to do is open it, you could use a hyperlink or by VBA:
[VBA] Shell "CMD /c c:\myfiles\wp\ken.doc"[/VBA]
or.. as an alternative:
[VBA]
Option Explicit
Sub OpenDocFile()
' ActiveWorkbook.FollowHyperlink Address:="C:\temp\help.doc", _
'if doc is in same directory as excel file
ActiveWorkbook.FollowHyperlink Address:="help.doc", _
NewWindow:=True
End Sub
[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln