I have a macro that looks in a network folder and process all the file located in that folder.
The file names are basically AAAAAA-CC-Settled_YYYYMMDD.CSV or AAAAAA-ACH-Settled_YYYYMMDD.CSV

I need to process the files base on the YYYYMMDD part of the file name.
Is there a way to Sort the list of file returned by the fso.

here is my code.
Please Login or Register  to view this content.

Thanks in advance