give that this thread was just created: https://www.excelforum.com/excel-pro...e-folders.html

these blocks of code should be used by people here quite a bit, I would assume. Change the inner workings of them to do what you need, as appropriate:

LOOP FILES IN A SINGLE DIRECTORY
Please Login or Register  to view this content.
LOOP FILES IN ALL SUB DIRECTORIES OF A SINGLE DIRECTORY
Please Login or Register  to view this content.
LOOP SUB DIRECTORIES IN A SINGLE DIRECTORY (method 1)
Please Login or Register  to view this content.
LOOP SUB DIRECTORIES IN A SINGLE DIRECTORY (method 2)
Please Login or Register  to view this content.