VBA script to substitute text from an excel sheet into various word docs by filepath

Originally Posted by tomca

Hi David,

My company doesn't use templates

Never too late to start.

that will do a substitution of existing word docs based on the items in the square brackets only...

Ok. After you replace the square brackets (or any string) with the data, how will you find that data again? That was the point of using the template. Every time you create a new document, the brackets will be waiting to be replaced.

We could use bookmarks, but those are too easy to delete by users.

We could use formfields, but you have to protect the document in order for the fields to work correctly.

Maybe content controls as you can set a 'not delete' property for those.

Wait, are you just trying to grab the data from an already completed file? If so, you might be able to search for the title and grab the next line down.

The target word file is just a place for me to refer to the word doc wherever it is sitting on the server,

Ok, I think I have a solution for this.