Macro To Generate.doc From.xls
October 31st, 2009
I have an Excel database that contains 9 fields (and 150×9 entries). I would like to have an automated clean and structured Word extraction of the entire database with 4 database fields used as section and subsection headers.
Both the target Word template and the Excel database structure are enclosed. What I need is a process or macro to automatically generates the Word output from the Excel
Solution needs to be flexible so that I can possibly add a 10th field and add/remove possible values for the fields that are used as section and subsection headers.
The production time is short as I need the tool by Friday 6 November.
