Below to is a table simulating my excel and my word doc is in the text below. I think the best way to get an exact match is to write a regular expression, the meta code for it is also below. I am new to this so I am not 100% sure if the regular expression route is the correct way to go. Thanks again for all the help.
search_list = []
i = 0
For All the Cells in Column A: 'Range("A" & lngCell).Value
search_list.append(all values in column A)
re.search(^ search_list[i]$)
i = i +1
Test 1 |
C:\Users\sferrier\Desktop\Replace Test\Exhibit1.png |
Test 10 |
C:\Users\sferrier\Desktop\Replace Test\Exhibit 10.jpg |
Test 1 |
C:\Users\sferrier\Desktop\Replace Test\Exhibit 100.jpg |
Word Doc
Test run, I hope this Macro finds exactly Test 1 and places a hyperlink to Test 1. It should not replace Test 10 or Test 100. I also hope that my color change does not change random number like 5, 12, 45, or 25 to blue underline.