Hello,
I have spent the whole day looking for a macro that would allow me to list and count folders and their subfolders BUT excluding the sub-sub...folders. I would be very thankful if someone could provide me with such a macro that would:
1- Ask me to browse and choose the main folder
2- Look for the folders under the main folder and their subfolders only
3- List and count the files and folders in both the folders and their subfolders
4- put the results on the same sheets everytime I do run the macro
I suppose my ask is complex and would require some time to build, but I would really appreciate any help from the experts!
Many thanks upfront.
A.
I have spent the whole day looking for a macro that would allow me to list and count folders and their subfolders BUT excluding the sub-sub...folders. I would be very thankful if someone could provide me with such a macro that would:
1- Ask me to browse and choose the main folder
2- Look for the folders under the main folder and their subfolders only
3- List and count the files and folders in both the folders and their subfolders
4- put the results on the same sheets everytime I do run the macro
I suppose my ask is complex and would require some time to build, but I would really appreciate any help from the experts!
Many thanks upfront.
A.