I am after a macro that will list all the files and sub folders in folder x and then also list all the files and sub folders that are in the sub folders of x and so it goes on.
This is where it becomes extra complicated. For each sub folder of X I want a new work sheet listing the files and sub folders of the folder x sub folder. This I have done.
I am now struggling with getting the files names and sub folders and was wondering if anyone already has a macro I could scrounge to help me along.
Folder X
sub folder year 2017
list of files in year 2017
sub folder January
The above is where am.
I have made a good start but if anyone already has a macro that does it all I'd be grateful if I could use/look/modify it.
thank you in advance
smiler44
This is where it becomes extra complicated. For each sub folder of X I want a new work sheet listing the files and sub folders of the folder x sub folder. This I have done.
I am now struggling with getting the files names and sub folders and was wondering if anyone already has a macro I could scrounge to help me along.
Folder X
sub folder year 2017
list of files in year 2017
sub folder January
The above is where am.
I have made a good start but if anyone already has a macro that does it all I'd be grateful if I could use/look/modify it.
thank you in advance
smiler44