open word document

K

kari

i need to open microsoft word, open a .doc file, paste some info from excel,
then close word again with VBA.

i've been able to get word open, just not a specific document.

Any ideas?

kari
 
R

rjtaylor

I am working on something like this also.
I have this so far to open I just cant save it yet

Sub ttt()
Dim wdapp As Object
WBPath = ThisWorkbook.Path
WBPathPlus = WBPath & "\Starting Files\Bidding information.doc"
Set wdapp = CreateObject("Word.Application")
With wdapp
.Documents.Open Filename:=WBPathPlus
.Visible = True
End With
Set wdapp = Nothing
End Su
 
Top