by the modulus value but the individual items are not sorted within the modulus range.
I have merged the sorting solution of user @Papasmile referenced in the comment of user @LocEngineer with your code (all credits to them): Sub Merge() Dim ...
If the files were created on set dates you can just sort them by date in explorer. I'm guessing this is not the case. So if you rename files as Molly ...
Using SSIS ForEach Loop containers to process files in Date Order
File Name Date Format YYY-MM-DD to Sort in Ascending or
Is the problem that the returned file names are not always in order? If so then adding a sort step should fix it: Code: Sub Merge() Dim bookList As ...
The file names of records relating to recurring events should include the date
Where the remaining file name is still meaningful within the context of the
By pop-up menu, then choose the sort order, such as Date Modified or Name.
1. Consider how you want to sort and retrieve your files · Start off your filename with the most important parameter. · For dates, use YYYY-MM-DD (or YYYYMMDD, ...