List all Folders and Subfolders only NOT files

[bobaol]

Hello, I'm trying to list all folders and subfolders in the C drive. I want all folders and subfolder levels to the end. So, if there are like one folder and it has another subfolder, and a subfolder under that, I want it listed. But, I do not want any files listed. I am only interested in finding all the folders that exist. Thanks advance.

 

[Dan_W]

Sure - no problem. This was the first result on the first page of a google search using the title of your post and "VBA" in the search field (link). I've checked it and it does what you want.