I need to transfer information from my excel spread sheet into an existing pre-formatted word template using VBA code.
The pre-formatted word template contains different sections with both text and tables.
I need to locate and update/replace text in the different sections of the word document from information from my excel spreadsheet.
And also locate each table and insert information from my excel spreadsheet into the correct cells/tables in the different sections of the word document.
Can anyone advise me with sample VBA source code to do this.
Thanks
Bookmarks