Getting a range from Excel into a Word document  
Author Message
marica





PostPosted: Top

Excel Programming >> Getting a range from Excel into a Word document

Hello All,

I am trying to get a named range into a word document.....I have thi
code....

It creates a word document correctly with the right path however, ho
do i get the named range into the word document??

Any Ideas??

Thanks - Dani

Sub MakeWordFile()
' Creates Word document
Dim WordApp As Object

On Error Resume Next
Application.ScreenUpdating = False

' Start Word and create an object
Set WordApp = CreateObject("Word.Application")
With WordApp

Excel113