I have this macro (which I will put at the bottom of this post) which runs perfectly fine at creating a directory list...until I ask it to do a directory with lots of records. It gets to record 32767, and overflows. Error occurs while executing the DoFolder Sub.
Anything I can do or modify to let it complete the task at hand? The folder has over 100k of files to list.
Please Login or Register to view this content.