Hi experts,

I have a directory with a couple of thousand CSV files, and I need to get the number of records in each file as well as the total number of records in all the files. How can I write a VBA script to accomplish this? I have tried a script that merges all the files but this is very time consuming and often times the merged file cannot hold all the records from the source files.

Thanks in advance for your help!
Cheers,