I'm not sure if this is even possible; but if anyone were to know, it'd be you folks!
I have a specific folder (C:\xxx\xxx\xxx\Folder) that contains several .xlsm files (among other types).
The last 6 characters of each filename is a number (IE: TEST_NAME 010203.xlsm, TEST_NAME 011403.xlsm, TEST_NAME 112112.xlsm, etc)
I'm looking for a formula that will search within that specific folder; determine which ".xlsm" file has the highest last 6 characters, and display those characters in the cell.
Is that even possible with a formula? If not, would it be possible wtih VBA?
Thanks for any light you can shed!
Bookmarks