Excel VBA – Get List of All Subfolders – In a Folder

Excel VBA Dir – Directory Listing – All Subfolders

Just input the Root folder path for this Macro. It will fetch all the subfolder & folders under subfolders till its last child folder.

It is a complete code that will be used to search or process all the files in a root folder.

Excel VBA – All Subfolders – List in Folder

Just copy paste this code into your VBA project. It will loop through all the subfolders in the root directory & present the directory listing in worksheet2.