Dear Friends

I would like a macro that runs automatically on word document open, such that it replaces placeholder text in a word template with data from an existing excel file. The template then saves the edited document with a new name so that it does not permanently affect the template itself. I would like to write this macro on a word document rather than an excel spreadsheet. The excel file and word template will all be stored in one folder, so the location paths should be relative.

Here is my code so far:
Please Login or Register  to view this content.

I have an excel workbook named madokero18a with a Sheet named Assign.


Somebody please help!!! Thanks.