Get list of files and sub folders (1 Viewer)

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

Something like this one?
https://www.access-programmers.co.uk/forums/showthread.php?t=240778

sorry I never got notification of a reply.

Thank you RX_ I will check

smiler44