Paste Excel Range into Word Doc at certain place

This is one way to do it...

Please Login or Register  to view this content.

Another way would be to put a 'placeholder' table into the document and use code like:

Dim wdRng As Word.Range
Set wdRng = oDoc.Tables(1).Range
wdRng.Tables(1).Delete
wdRng.Paste

where the 1 in 'oDoc.Tables(1).Range' is the table's index # within the document (it's always 1 for 'wdRng.Tables(1).Delete', though).

With this approach, you can replace the table as often as you like.

Originally Posted by v.edwards.jr

Thanks for the help guys! The first option seems easier for what I need, but it's still not working. Even with this change, the table is pasted at the top of the document. I replaced this section of my code:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

The text "PASTE TABLE HERE" is definitely in the Word doc that Excel opens. Still not working...what am I doing wrong?

If I use the second option (macropod), how do I know what the table's index # is?

It looks like you did it right. Not sure why it doesn't work.

Another method is to set a bookmark (named PTH in this example) for the "PASTE TABLE HERE" text in your template. Then use this code.

Please Login or Register  to view this content.