I need to hyperlink a file to a cell based on partial filename in a cell. What I would like to do is type partial filename in the cell B2, i.e., 1324 or 1562, and as I type partial filename and hit "enter", it will search the directory and sub-directories for that number, and hyperlink to the file it finds with that number, i.e., CCB_1324, in cell C2. Is this possible?
I am pretty fluent in VB so if someone can just get me started I'm pretty sure I can finish.