Comparing sets of strings to find the latest file in a folder

Hi all!

So I have files timestamped with "somestuff # 09-17-12.xlsx", where the date (09-17-12) changes everytime I create a new file according to the date it is created (we assume here that there is never more than one file/day created).

I want to compare a batch of files with different dates and for VBA to pick out the most recent file according to this method.

So far I have managed to isolate the 09 as the Month, the 17 as the Day, and the 12 as the year, and now am looking at comparing using nested if clauses for year, month, and day (as necessary), in order to find my most recent file.

Here is my code so far:

Please Login or Register  to view this content.

Thanks again!


Moderator Edit:

Welcome to the forum, Dunctonsteel.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

try this

Please Login or Register  to view this content.