Open Word

[Confused]

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

[paulw]

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.

[Confused]

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

[paulw]

Yes, use

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

Cheers,

Paul.

[Confused]

Many Thanks!!

[tumblingdown]

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


;-)


Beer on friday.

td.