I want to create a macro in word which will find words listed in excel and replace the words in MS Word Document.
For example - In my excel the sheet contains 2 columns, 1st column Words_to_Find & 2nd column Words_to_Replace!! The list of words are Abbreviation, (Eg: DBS -Deep brain stimulation) . I want to replace the first instance in the document. Suppose if the full-form is not written in 1st instance the replace it ,
For Eg [ (DBS) has shown wide applications for treating various disorders in the central nervous system by using high frequency stimulation (HFS) sequences of electrical pulses. ]
In the above line DBS will be replaced by Deep brain stimulation but in the pattern of underline word in the above sentence. It will replace the word with "full-form (abbreviation)".
I am attaching Excel and word document.