Cycle through all .xlsb files in a folder in size order (largest first)

[cochise]

Is it possible to create excel vba code to cycle through and open all .xlsb files in a particular folder starting with the largest filesize first?
All methods I have seen so far use alpha order.
Many thanks for any help you can give.

[Norie]

The only way I can think of doing it would be to first read in the names and sizes of all the xlsb files in the folder to a list, sort the list by size and then loop through the list opening the files.

Something like this perhaps.

Please Login or Register  to view this content.

[cochise]

Thank you so much for your prompt response.
The code worked perfectly and I would never have thought to do it that way.