I'm trying to write a macro that will search for a file in a directory and then hyperlink the file.


in cell A1: i have a file name.

Like it to search for the file name in My doc folder and then place the hyperlink in cell A2

I know there is examples of filesearch but this is no longer available for 2007. could someone help me as i can't find anything that works for excel 2007.

thanks for the help.