Let's say I have a main folder with a path of
C:\2. SETTLED CLIENTS\

I want to loop through all the sub folders within it to extract information
from one file within each folder. I know the code for extracting the info and
opening the file.

Each subfolder is of the name "Surname, initial"

What I don't know is the code to open each subfolder in sequence, without
using a list of names.
Regards, Brett