First Use Acronym Spelled Out

Would like a macro in Word (written in VBA) to do the following steps in this order:

1) Prompt user to browse for excel file (excel file will have 2 columns updated by the user: Column A are acronyms spelled out, column B are the acronyms. For example A1=Visual Basic, B1=VBA)

2) Global search word doc for first entry in column A and global replace with first entry in column B. Repeat global search and replace with 2nd, 3rd through nth entries until column A is empty. Highlight the globa…

Leave a Reply

Your email address will not be published. Required fields are marked *