Hi,
I'd be grateful for some advice on the following VBA requirement I have, which I imagine has been created in one form or another but I've not been able to track it down.
The company I work for has a word doc template for an inspection report. The user has to edit each report and fill in the data about a property. It would be useful to edit the data in a centralised work sheet, and then have this placed in the respective word documents for each property using either a substitution approach. I don't think mail merge is feasible as the company template is very and formatted with corporate branding etc.
Is it possible to create a VBA that, when you tell it the filepath of a word document, can substitute a string for another desired string contained in the excel sheet?
I've attached a zip folder which contains what I am looking to achieve.
Thank you
Tom
Bookmarks