The attached Excel document demonstrates the ability to open a file by searching a specified folder and its sub folders. The parameter used is the file name (without the extension) entered in an input box.
This is useful if you need to open a file that is normally saved with a unique ID, Reference or Code. Also useful if you need to open a specific Excel file and run a macro on it by providing the file name.
You only need to change the path to your folder containing sub folders.
Enjoy!
My references include:
Ron de Bruin @ http://www.rondebruin.nl/fso.htm
Chip Pearson @ http://www.cpearson.com/Excel/RecursionAndFSO.htm
Bookmarks