How to iterate through a VBA array alphabetically

Question

I'd like to know if there's a convenient way to sort a returned list alphabetically in VBA when the 'Dir' command is used. For example, if I find files using:

strPath = "C:\path\to\pics\"
strFileSpec = "*.png"

' -------------------------- '

strTemp = Dir(strPath & strFileSpec)

how can I iterate through them alphabetically?

Thanks in advance!

Community · Accepted Answer · 2018-05-08 21:48:18Z

4

VBA doesn't have a built in array sort function. Fortunately, this problem has been solved already by others.

This code was written by Chip Pearson and can be found on his website. It implements the quick sort algorithm.

You can use it like this:

QSortInPlace(InputArray)
For i = lbound(InputArray) to ubound(InputArray)
    ' process array items
Next i

edited May 8, 2018 at 21:48

CommunityBot

11 silver badge

answered May 26, 2014 at 16:05

RubberDuck

12.9k5 gold badges56 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to iterate through a VBA array alphabetically

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related