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 ?
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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.