Listing number of files per folder?

[dark91zc]

Is there a way that I can list how many files are in each folder that is imported to my spread sheet? Can this be done to include folder size? I am new to VBA programming and trying to learn fast.

Thank you

[Jakobshavn]

Here is some VBA that allows you to pick a folder and then tells you how many files it contains:

Please Login or Register  to view this content.

[dark91zc]

Is there a way to get it to print the folder name and the count number into a couple cells?

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[dark91zc]

Ok cool working better. Is there a way to have it do this function with a main folder then check all of the sub folders?

[Jakobshavn]

It might be possible using the FileSystem Object. I suggest you open a new thread and mention what we have accomplished so far.

[dark91zc]

ok thank you very much i added rep to you

[Jakobshavn]

Thank you for the feedback!