I've resolved some issues with opening files w/unknown extensions (.xls, .xlsx, .xlsm) and preventing code from crashing when a file (with a known extenstion) does not exist.
http://www.mrexcel.com/forum/showthread.php?t=547920
http://www.mrexcel.com/forum/showthread.php?t=533029
Now, I would like to know how I can resolve a combination of these issues.
How would I code to open a file by a derived name with an unknown extension and NOT crashed when the derived file name does not exist (regardless of the extension)?
Basically, I'm working with 2, possibly 3 files. The code runs in the Master file (1), utilizes the revision date of a Daily file (2) to then open the source file (3) that includes the aforementioned date. However, that source file has situations when it may not exist and/or could possible have the different excel extensions.
http://www.mrexcel.com/forum/showthread.php?t=547920
http://www.mrexcel.com/forum/showthread.php?t=533029
Now, I would like to know how I can resolve a combination of these issues.
How would I code to open a file by a derived name with an unknown extension and NOT crashed when the derived file name does not exist (regardless of the extension)?
Basically, I'm working with 2, possibly 3 files. The code runs in the Master file (1), utilizes the revision date of a Daily file (2) to then open the source file (3) that includes the aforementioned date. However, that source file has situations when it may not exist and/or could possible have the different excel extensions.
