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.

I need a VBA script that will look into my Word document and replace all of the English acronyms to French acronyms. I’m not experienced in VBA so I don’t know where to start. I have enabled VBA in both Word and Excel. Should I write the VBA script in a module in Word or Excel? Could someone paste a code for me to copy so that I have an idea of what to do?

Thank you very very much!

I tried several scripts that I’ve seen online, without any success.