Looping through directories AND subdirectories, vb.

[OdinsDream]

I'm trying to figure out the code to loop through all subdirectories of a given Root Folder. I'd like to do this to any depth, so if it were:

RootFolder1Folder1AFolder1A1

RootFolder2Folder2A

RootFolder3

I'd like to get down to Folder1A1 without writing code to handle X number of levels. How can this be done?

 

[tusharm]

http://www.mrexcel.com/board/viewtopic.php?topic=14175&forum=2