Open Word

Does anyone have code that will open a word doc from Excel?
Thanks!!!

You could use CreateObject(...) - slow

or, quicker

Dim myWord As Word.Application
Set myWord = New Word.Applicationn etc.
(but you'll need a reference to the Word library to do this)

Cheers,

Paul.

I know this is basic but ..... if the word document you want to open already exists can you reference that in your code?

Yes, use

Code:

---

Dim wObj As New Word.Application
 
wObj.Documents.Open FileName:="MyDoc.doc"

---

Cheers,

Paul.

Many Thanks!!

Oi! Paul! pack it in with that in-line New ****. You early binding bas*ard!


;-)


Beer on friday.

td.