Searching for folders

I have a lot of nested folder which needs to be sorted out.
It would be a lot easier if I would have some code which would go trough all my folders and makes a list of each folder which has a subfolder called Mapping.

For example search trough all folders in C:\Temp

C:\Temp\folder x\ other folder\Mapping would return C:\Temp\folder x\ other folder
C:\Temp\folder x\ other folder\folder y\ would return nothing as there is no folder called mapping

but if there is then inside:
C:\Temp\folder x\ other folder\folder y\folder z\Mapping it would return C:\Temp\folder x\ other folder\folder y\folder z\

Hope you understand and can help me. I have no idea where to start with this. Couldn't find any help so far on the internet.

Hello Tjeu,

Not sure if this what you are looking for, but it should be a good start. This macro will create an array of all folders and subfolders for a given directory. There is another macro to list the array on the active worksheet in column "A".

Please Login or Register  to view this content.

List Folders on the Active Sheet

Please Login or Register  to view this content.

Hello parrynz,

Thank you glad it helped.