Re: Sorting Folder Contents
Code:
Function getLowestMatch(arrIn())
Dim i, j, strBuff
strBuff = arrIn(LBound(arrIn))
For i = LBound(arrIn) + 1 To UBound(arrIn)
If strBuff > arrIn(i) Then
strBuff = arrIn(i)
End If
Next
getLowestMatch = strBuff
End Function
Dim oFS, oFolder, oFCol
Dim arrFolders(), i
Set oFS = CreateObject("Scripting.FileSystemObject")
Set oFCol = oFS.GetFolder("H:\").SubFolders
ReDim arrFolders(0)
i = 0
For Each oFolder In oFCol
arrFolders(UBound(arrFolders)) = oFolder.Name
ReDim Preserve arrFolders(UBound(arrFolders) + 1)
Next
ReDim Preserve arrFolders(UBound(arrFolders) - 1)
MsgBox getLowestMatch(arrFolders)