initial.xlsm - Macro-enabled Excel file containing the VBA script; template.docx - MS Word template file VBA script replaces text in; initial data.xlsx - a dictionary of items to be replaced; sample ...
All you have to do is copy and paste the script inside the developer's guide on a excel sheet (for that, create a module), change the path inside the script to the folder you would like to automatize, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback