How to find a specific file on a folder from an output cell in a worksheet and create a link to it?

[Kaliman007]

Hi, I am absolutely new to VBA and I am trying to create an excel worksheet that would let me select from lists of 3 or 4 options (e.g. Board type, board number, version, etc) and output the file name in a cell. Well, I got this far. Now, I want to use the "file name" in the output cell to search a folder on a directory for that file and create a link to the drawing. I want to be able that once the file is found, that I would click the link to it from the worksheet and the drawing will open. Also, there is 2 types of file extensions PDF and TIF. Is this possible to do with VBA? Need help. Thanks.