search folders and create hyperlinks to files

Hi, i have found this code that will search a Dir then add hyperlinks, i need to do this with my sheet however, how do i modify this so as that the code will search cell ranges?

what i need it to do is search through E55 to E60 then J55 to J60 and apply a hyperlink to any cell with text in it.
the text in cell will be the name of a file in my root directory eg DYAIES-001, this text will always change as this is a template that many people will use.

directory patch e:\IsolationDataBase\IsolatorImages
i need to add the hyperlinks to the same cells mentioned above, not in another row like this one does
thanks for any help

Please Login or Register  to view this content.

bumpies

anyone have a couple of ideas?