Macro To Identify & Highlight Words In MS Word Based Upon A List In Excel File Column

abhimanyu · #5 03-20-2020, 09:09 AM

Quote:

Originally Posted by gmayor

Another approach would be as follows. Name the column of Words (without empty cells and omitting the header row if any) as WordList. Then run the following to highlight the listed words. Change the value of strWorkbook as appropriate.

The Excel range is read into an array (without opening Excel) and that array is interrogated to get the words.

Thanks a ton Graham. Let me check this out as well.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight words from a list	Nanaia	Word VBA	3	09-07-2018 02:13 PM
How to find (highlight) two and more words in a list of 75k single words in Word 2010	Usora	Word	8	05-29-2018 03:34 AM
Macro to highlight a list of words	bakerkr	Word VBA	4	10-19-2017 02:23 PM
Macro to highlight repeated words in word file and extract into excel file	aabri	Word VBA	1	06-14-2015 07:20 AM
Highlight Words from a Word List	JSC6	Word VBA	1	09-30-2014 08:22 PM