PDA

View Full Version : Open a specific word doc



Neodubois
10-31-2008, 03:52 AM
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 ?

GTO
10-31-2008, 05:10 AM
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

Kenneth Hobs
10-31-2008, 05:14 AM
If all you want to do is open it, you could use a hyperlink or by VBA:
Shell "CMD /c c:\myfiles\wp\ken.doc"

lucas
10-31-2008, 10:07 AM
or.. as an alternative:

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