I have a large Word file that refers to multiple Question #s throughout.
I also have an Excel file that lists all the Question #s in Column A and in Column B there is a list of actual questions that are also hyperlinks.
I would like to replace every question # in the Word document with the corresponding hyperlinked question in Column B of the spreadsheet.
I tried to use the macro in the StackOverflow question Multiple find and replace in MS Word from a list in MS Excel, but I get the Run-time error ‘1004’: Unable to get the Special Cells property of the Range class. I am not sure what this means or how to fix it.
Also I am guessing this macro needs adjusting to be able to insert the hyperlinked text that is in Column B.
Thanks for any help!
PS We have been doing this manually and annually for 4 guides with over 100 questions in each guide for the past 15 years. I so want to figure out a way to automate!!