How do you search a folder for a cell item " NAME", then return a hyperlink if found?

Hello all,

I am looking for a way to have my spread sheet search a folder with PDFs based on an item name in a call like "CO DETECTORS" IF another cell I have has a "TRUE" in it, and if the name is listed on the PDF file name return a hyperlink to that PDF file.

Can this be done?

example:
IF cell D1 is "TRUE"
Search for file name of cell D2 "CO DETECTORS" in a folder on my hard drive "C:\Users\user\Pictures\MP Navigator EX\2012_05_30"
and if file name found give cell D3 "HYPERLINK" to that file!

Thanks to all that take the time to look at this question, Jerry.

try this:

Please Login or Register  to view this content.

will you interrogate all of the cells in column F separately, or do you want to find links to all the filenames in column B if only F7 is checked?
assuming the former, try this:

Please Login or Register  to view this content.

Thanks again for getting back to me NickyC,

I would like to interrogate all of the cells in column F separately.
I need to treat each row separately with its own hyperlink to the column B name PDF of its row, IF column F for that row has "WX" checked.

example: If "WX" Checked in column F of row 100 then return Hyperlink in column H of row 100 to the name in column B in row 100.
If "WX" not checked in column F of row 100 then no hyperlink in column H of row 100.

The same should be true of each row independent of each of the other rows.

I hope this helps.

hi the macro above should achieve that

ah - sorry; try this:

Please Login or Register  to view this content.

You are the BEST!! Works like a charm, What can I do for you?

You have saved me hours and hours.

no worries - glad to help

NickyC, I can't Thank you enough, you are a VBA god!