Opening a Word document from Excel
There might be a more elegant way, but this should work:
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"
MyDoc.Windows.Parent.Activate
"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
|