>From within my Excel macro, I want to open a specific word document and
paste part of my spreadsheet into a specific part of the word document.
Anybody know how?
Thanks,
RobH
>From within my Excel macro, I want to open a specific word document and
paste part of my spreadsheet into a specific part of the word document.
Anybody know how?
Thanks,
RobH
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
With WordApp
.Documents.Open "C:\Filename.doc"
.Visible = True
End With
WordApp.Quit
Set WordApp = Nothing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks