Open all files in a SharePoint folder (Problem: Files open out of order)

My below code is working well with one exception. The workbook opens up each file in a SharePoint directory and copies some data over to the initial workbook. My issue is that the files open out of order which makes the copied data also out of order. Sorting after the fact is not an option as I am also dealing with merged cells. The names of the files I am opening are similar to:

T1 Plan.xls
T2 Plan.xls
T3 Plan.xls
T4 Plan.xls

The code below doesn't open the files in order i.e., T1, T2, T3, T4, etc. Instead it opens them T1, T3, T2, etc.

Any ideas would be much appreciated!

Please Login or Register  to view this content.

Suggest dropping the filenames into a spare column, sorting them and then go down this sorted list to open in the desired sequence. An alternative is read the filenames into an array to perform a bubble sort prior to opening the workbooks.