Looping through Subfolders within a Parent Folder

I have a macro that is designated to run on workbooks within a subfolder but in order to run it I need to first be able to have the Macro open a parent folder, then open each sub folder individually-- at which point my Macro can be run. The parent folder is called lots and the sub folders are all named as a series of digits. The Macro that I want to run creates a report based on data within the sub folders. I was thinking of having the user save the report in the lots folder in order to get the users file path and then using that file path to tell the computer where to begin looping through subfolders.

I am still new to VBA and having trouble with loops, any help would be appreciated, thanks.

This Macro is only capable of being executed once the user has saved the report within the subfolder. I need something to first open the subfolder

Please Login or Register  to view this content.

No, the subfolder already exists. Like I said the parent folder is called lots and the subfolders are all named by a series of digits. Ex. 130050. I need the macro to be able open 130050 and then run what I already have

Thank you very much. Would you also be able to assist me in determining where to place this piece of code?