Good Morning/Afternoon/Evening!

I would like to learn how to designate directories for Excel or the user to search for auxiliary files, such as a document template. I would like to learn not only how to enable the user to search all directories, but also how to let the user search a directory that I specify and not anything else, if possible.

In addition, I need to learn how to tell Excel to look in:

The same directory it was run from for a specified file
The users "My Documents" directory for a specified file

By stating "a specified file" I mean there is no user interaction - I hard coded the file name into the VBA and I just want Excel to look for that file in the directory, so Excel can use it if it exists and give me a means to go another direction if it does not exist.

If anyone knows of a good reference for this kind of material, I would benefit greatly from that!

Thank-you very mush, I do appreciate the help.