VBA to replace codes in a word template with values from an excel table
I am trying to build a code that opens a word template, finds all instances of codes that are listed in an excel sheet, and replaces them with values that are in the column next to the codes in the excel sheet.
Find and replace text in Microsoft Word using an Excel spreadsheet
I have a Word document written in English. The English acronyms need to be translated to French.
I also have an Excel spreadsheet. Sheet1 has the English acronyms in column A, and the French acronyms in column B.