Results 1 to 6 of 6

Thread: Find and Replace with Hyperlink Doc from Excel - 438 Error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    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.
    Last edited by sferrier; 03-18-2019 at 07:07 AM. Reason: Not finished

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •