View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
PaddyMac[_2_] PaddyMac[_2_] is offline
external usenet poster
 
Posts: 15
Default Opening a Word document from Excel

JLGWhiz

Thanks for that - just about to try it out - please forgive the double
posting I repeated today - couldn't find my original and thought it hadn't
gone up.

Kindest

"JLGWhiz" wrote:

The last line did not belong with that snippet.

Dim MyDoc As Object
Set MyDoc = GetObject("D:/msword/directory/document.doc")
MyDoc.Application.Visible = True
MyDoc.Parent.Documents.Open FileName:="D:/msword/directory/document.doc"

"PaddyMac" wrote in message
...
I wish to put a commend button in an Excel spreadsheet which will open
an existing word document.

i.e D:/directory/document.doc

What code would I put behind the command button?

Any ideas?

Many thanks

PaddyMac