Dear all,

This is my situation, I'm working with Excel 2007 and I have this file full of sheets and tables.
Each week I need to create a Word report (extracting data from excel file and eventually making some calculations), with always the same structure.
It has basically a graph with hystorical data, and some tables (changing each time in size in terms of rows).

Now the idea is to have a vba macro in the excel file that automatically fills in the word document.

Since now, I was able to create a vba macro that creates a table in a corrispondent bookmark of the word document, from a selected region of the excel.

I would like to know what should be the best way to do that in your experience (using bookmarks and than format the table as needed, adding data inside a pre-formatted table on the word document managing rows as needed, use sections instead of bookmarks, using a docx instead a dotx, anything else).

Anyone with experience on that?
Any examples to which I can refer to, please?

Thank you for your advices and time,
dk