Macro to search folder including subfolders for file and open

Hi,

I'm trying to make a macro that searches through a master folder and its subfolders for a files that start with the Code (eg: Code123) where the 123 are what users would input through the inputbox function. Using the code provided by jbeaucaire to loop through subfolders some time ago, I tried to incorporate inputbox into it but the macro would simply run and do nothing. How do I make it loop through each subfolder to look for a certain code number until the code is found and opened? The code i have is as below:

Please Login or Register  to view this content.

I tried using a more straight forward approach but the code didnt work.

Please Login or Register  to view this content.

This is my first try at VB. Advices are greatly appreciated.

Thanks a lot.

Sam.