L
Legacy 96851
Guest
Pretty much the thread title is what I need to do. The files in the directory have to be in alphabetical order, and I need my macro to collect data from all of them. However, it should start at the letter T, not A (then after it gets to the end (Z), loop back around from the beginning (A-S)). Here is the code I currently have that does them in alphabetical order.
Code:
sourceName = ActiveWorkbook.Name
sourcePath = ActiveWorkbook.Path & "\"
sumfile = Dir(sourcePath & "*.xls")
While sumfile <> ""
'stuff it does with the file'
sumfile = Dir()
Wend