Access VBA Count Specific Kind of Files in a Folder

Question

For example, I have following files in a folder

aaa001.txt

aaa002.txt

aaa003.txt

bbb001.txt

bbb002.txt

...

Is there any way I can count the number of files starting with "aaa" in this folder?

I can do Dir("*\aaa*.txt") in a loop while counting. But I'm wondering if there is a more efficient way of doing it.

Thanks.

Even though it is counting as you are, this answer details out some good code http://stackoverflow.com/a/22630255/1504882 — Elias, Jul 18 '14 at 12:12
Dir I believe is the way to go. Another resource here as well http://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba. If its running too slowly, maybe post what code you have so far, the issue might be the way it is setup rather than the function being expensive — ashareef, Jul 18 '14 at 12:14

score 0 · Answer 1 · answered Mar 19 '16 at 09:08

0

I'm wondering if there is a more efficient way of doing it.

No. Dir is simple and as fast as can be.

answered Mar 19 '16 at 09:08

Gustav

1 Answers1