Paste Range of Data from Excel to Word

[ericbartha]

Hello!

I am trying to append data, copied from MS Excel, to an already existing table within MS Word (table(1)). When I do this manually, I find exactly what I am looking for - "Merge Data (M)" under paste options, however, I cannot figure out how to reference this with VBA.

2016_12_06_14_32_37_.png

Everything I try with VBA, mostly PasteAndFormat, pastes the data ABOVE the selected table, instead of appending to it. Worth noting, the existing table is only the headers, as the DOC is a templete for 10,000+ PDFs being created.

Anyone have an idea?

TIA,

Eric

[Tinbendr]

You will likely have to set the insertion point to cell(2,1).
Along the lines of:

Please Login or Register  to view this content.

Then attempt the paste.

[vichopalacios]

Hi ericbartha

When checking both your posts, this one, and
http://www.excelforum.com/word-progr...ord-table.html

I found in the web some coding and adpted in a way that could help you.
It uses a Word document which is in the same directory as the Excel Workbook.
The Doc must be closed.

The Doc has one table, only the first line with titles.
In the code you should define the number of rows and columns to be copied
You can vary them to automatically obtain those numbers from the data table using lastrow and lastcolumn coding.

Please Login or Register  to view this content.