Hi,
I am using excel 2007 and have not been able to find a solution to my problem on any forum or internet source. I have a Parent directory that contains several folders and these folders may or may not contain subfolders aswell. I would like have the 2nd level folder names copied to a worksheet and in the adjacent column the number of files contained within those folders (which may or maynot contain subfolders). Any help would be greatly appreciated Thanks in advance!
Folder Structure
Parent : C:\Test
Second Level Folders: C:\Test\test1
C:\Test\test2
Second Level Folders: C:\Test\test2\subtest2-1
C:\Test\test2\subtest2-2
C:\Test\test3
Worksheet Result
Column C Column D
test1 5
test2 10 (this value would include files found in the subfolders)
test3 3
Bookmarks