Hi,

I am trying to use VBA macro in order to do the following:

1) In some Excel file an end user marks chosen rows of some given table that has, for example, 3 columns.

2) The VBA macro collects the data into a matrix and opens an already existing Word Template (.dotx file).

3) Now it replaces two bookmarks that are located in the Word Template, by the matrix data taken from Excel's columns #2 and #3.

4) The macro saves the modified Word Template as a .docx file, which its name is determined by Excel's column #1 data (if such .docx file already exists, it is replaced by the save procedure), and closes the saved .docx file (and also cleans the memory that is used for the save procedure).

5) Then the macro recovers the replaced bookmars in the Word Template (.dotx file) and returns on steps 3 to 5 until the end of the matrix.

6) After saving all the needed .docx files, the Word Template (.dotx file) bookmarks are recovered, than it is saved and closed.

7) All the used VBA macro Variables are cleaned (turned in Nothing) and the program stops.

Can you please help me to write the outlines of such program?