VBA code to loop directories, subdirectories and files

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.