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.
Bookmarks