I have a Word and an Excel file. The word document is an existing file, with a lot of text in it.
In the Excel are tables. I want a VBA Word macro that Copy Paste the tables from Excel to Word. The macro must be a Word macro. Not a excel macro.
The tables that are being paste in Word must look exactly like the tables as in Excel. Same letter type, colours, border, bold etc.
I want some kind of reference point in Word for each tables. So it is easy to modify the were input Excel tables.
I want something like this:
Write comment in Macro script so I know how to modify it later for more tables input in Word.
- Make a reference point in Word
- Copy a range in Excel
- Paste were the reference is in the Word document the values with the exact layout (letter type, colour) as in Excel
See sample Files.
Please reply asap. The job need to be finished in 24 hours!