Hi Airborne,

You're actually closer than you know... In the findall routine, the following line inside the file loop gives you the full path right to the workbook:

[vba]Set WB = Workbooks.Open(FileName:=SearchPath & "\" & FileName, ReadOnly:=True) _
', Password:="Uncomment and put password here if required"[/vba]
The WB variable can be used to set the target address of the hyperlink as it then holds the full path including file name. What we'll need to do is change the loop to close the workbook regardless of match or not, but add the hyperlink if it matches. It should be a pretty minor change overall. I'll take a look at it later tonight, if you don't solve it first.

Cheers,