Does anyone have code that will open a word doc from Excel?
Thanks!!!
Printable View
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
Cheers,Code:Dim wObj As New Word.Application
wObj.Documents.Open FileName:="MyDoc.doc"
Paul.
Many Thanks!!
Oi! Paul! pack it in with that in-line New ****. You early binding bas*ard!
;-)
Beer on friday.
td.