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

Hi David,

Thanks for the code. It works great but wasn't quite what I was looking for - I don't think I was being clear.

My company doesn't use templates so I'm more looking for something that will do a substitution of existing word docs based on the items in the square brackets only, and not something that creates new fresh word docs.

The target word file is just a place for me to refer to the word doc wherever it is sitting on the server, i.e. I don't need the script to make up filenames etc based on the property name as I can deal with this plus the folder path will be a bit irregular.

I've reattached before and after spreadsheet and word doc which hopefully makes it a bit clearer what I am looking for.

Thank you

Tom