Does FSO FileCollection have a limit as far how many files can be processed ?

AlexF777
AlexF777 used Ask the Experts™
on
For example, when I go:

                                    For Each objFile in Folder.Files
                                          whatever
                                    Next

What if I have 100000 files ??
Also, may be there are more economical ( in terms of memory, performance ) ways to handle such situation ?

Thanks in advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I don't know if there is a limit but I do know FSO is the slowest method of doing this.The fastest way would be to use API:

http://www.mvps.org/vbnet/index.html?code/fileapi/recursivefiles_minimal.htm
i agree with vinnyd

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial