Search for files on computer using cell value as search parameter

I would like to add a right-click shortcut menu macro that will search my computer for a PDF containing the selected cell's value (model/part number) as part of the file name. It will primarily be used to find brochures and datasheets, where the equipment model number is included in the file name. My normal file name format is [brand][model number][datasheet or brochure].pdf so the code would either look for an exact match (if the user knew he wanted a brochure only) or would use a wildcard. Ideally, if an exact match is found it opens the file. Otherwise, the found matches are shown, allowing the user to select the correct one. (But I would be happy if it just showed all the matches and allowed the user to select one.)

I am familiar with using the Hyperlink function, but I have learned today that it does not allow for wildcards. I am assuming I will be using something like shell execute to open windows explorer and run a search, but that's where I need the help.

I need to search all hard drives on the computer and mapped/shared network drives, if possible.

Thanks!

Eric

Is it within forum rules to BUMP? I would think something like this has been done before. I found something close one time but now I can't find it again.

I would be happy if it just opened up a normal Search Computer window, ran the search, and allowed the user to select the best match. I don't have a clue, working outside of Excel, and macro recorder is no good at that point.

I cross-posted this at the Code Cage

http://www.thecodecage.com/forumz/mi...-contents.html