Code only counts excel files as 1

Hello, 2 problems

My code counts excel files in folders 0-delegation, 3-Preload,6-Postload,8-Defects, 9-DVR as 1 only. Lets say i have 3 excel files in 3-Preload but it pops up as 1 in Excel.

The goal of this code is to count the number of files in each of those folders posted above. I ran it on our network drive which has over 50GB of data but it keeps freezing Excel. Is there anything I can do? I think that the way it is written, it keeps the data in it's memory. Can someone help me write a lighter code that goes through the filepath and to those folders to count files?

Thank you!

Please Login or Register  to view this content.

The 'C-XXXX part counts all the folders and excel files in the main folders. The '0-Delegation,etc. part of counts the excel files inside the subfolders. I actually figured it out! But I have a quick question, this macro takes 8 full minutes to go through 40GB of data on a network drive, is it because of my code? or my network is just very slow.

Maybe try using filesystemobject?

Please Login or Register  to view this content.

that will include non-excel files though, not sure if that its the goal.

Thanks, I actually found out the solution! I just added an If, Quick fix! Do you guys know why my code runs so long on the network drive (Which is slow). Does my code keep the data in 'memory' instead of just running through it and count?? It takes me over 8 minutes for 40GB of data approximately.

I was meaning as a way to speed the code up...

As far as I'm aware your code will not keep excessive amounts of data in the momery, you kind of answer your own question - the code takes so long because it is running on a slow network drive.

You could try monitoring the cpu/ram performance as you run the code to make sure I guess.