Excel to Word

[Hogg]

Hey all!

I'm having a problem with transferring data from excel to word. I've got the majority of the code done where I can select and copy the cells in excel and paste the cells as required into word. However I can't specify where I want the data to be inserted into word. When this goes into full operation there will be a lot of data to be transferred. I guess I need to use words bookmarks but I don't want to loose the paste special -> link function.

Any ideas?

Code so far:

Sub Excel_to_Word()
Dim wdApp As Word.Application, wdDoc As Word.Document, ws As Worksheet
    Application.ScreenUpdating = False
    Application.StatusBar = "Creating new document..."
    Set wdApp = New Word.Application
    Set wdDoc = wdApp.Documents.Open("c:\Doc1.doc")
 
    wdApp.Visible = True
 
    Sheets("Project Data").Range("B1:F16").Copy
 
    wdApp.Selection.PasteSpecial Link:=True, DataType:=wdPasteRTF
 
End Sub
 

[Dököll]

Hey there friend!

This looks to be the same code you have, but it looks your's is missing somehting:

Sub RangeToDocument()
' Set a VBE reference to Microsoft Word Object Library
 
Dim WDApp As Word.Application
Dim WDDoc As Word.Document
 
' Make sure a range is selected
If Not TypeName(Selection) = "Range" Then
    MsgBox "Please select a worksheet range and try again.", vbExclamation, _
        "No Range Selected"
Else
    ' Reference existing instance of Word
    Set WDApp = GetObject(, "Word.Application")
    ' Reference active document
    Set WDDoc = WDApp.ActiveDocument
    ' Reference active slide
 
    ' Copy the range
    Selection.Copy
 
    ' Paste the range
    WDApp.Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF, _
        Placement:= wdInLine, DisplayAsIcon:=False
 
    ' Clean up
    Set WDDoc = Nothing
    Set WDApp = Nothing
End If
 
End Sub
 
 

I bold the portion I think should do the trick for ya...

Let us know if that worked:-)

Whoops, bold does not work, been away too long. Look where you need to paste the data, perhaps you can use it to fit your needs.

Later!