View Single Post
  #5   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

It works perfectly!

Many, many thanks.

Kindest regards

PaddyMac

"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