Macro to copy table/range in excel to specifically defined word document

[Jon84]

Hi,

I use an excel workbook that contains around 20-30 output tables/ranges and i would to have a macro which will enable me to open a specific word document and paste these tables/ranges from excel into the word document. I am unsure as to how to get excel and word to "talk to eachother"???

To make things more difficult i would like to be able to set the paste location in the word document, and ideally i would the copy and paste function to be a normal copy and paste and not a paste special as the tables/rnage in excel have already been formatted correctly and column widths adjusted to fit the margin of the word document.

Currently I select the range in excel, switch to word and paste then continue until all tables/ranges are pasted. Not difficult but as certain calculations change these tables/ranges need to be re-cpoied and pasted to word which gets frustrating.

I understand if this is too much of a task but thought i'd put it out there.

Any help is greatly appreciated.

 

[andrewkard]

Hello, try copy each cell from excel and paste special with link to get a merge field.