Hi, I have some standard documents that I use regularly. I often have to change the names in the docs. For first name only I use ZZZZZZZZ and for first name and sirname I use XXXXXXXX in my template docs.

I tried and abandoned some time ago to try and make some VBA code where I could open a bunch of docs and have the replace command with 'match case' switch enabled and change my template name ZZZZZZZ and XXXXXXXX. I figured I could put the names I wanted to change to in a text file or an Excel spreadsheet, or text box then have the macro run through each doc.



I failed at the first hurdle.

Is anyone aware of a VBA script that will do what I want?

I have approximately 10 docs all uniquely named with XXXXXXXX in the document name. Can a replace function automatically change them too?