Thank you Bob, Jim and Don,

I will go with DIR as it seems the simplest and straightforward.
I note it only extracts the top level so I will have to iterate over
the first set of folders.

Many thanks for the other code which was very instructional.

Michael
================================================== ==


Michael Singmin wrote:

Hello group,

I am using Application.FileSearch
I don't want to extract any files, only the folder names.

I am assembling a fine art project with jpg images.
I have approximately 500 artists spread over 11 art movements.
Each artist has its own folder and the folder name displays his name,
birthdate and death date. I want to extract these folder names into a
worksheet.

Can FileSearch be used for my application ?

Thanks,

Michael Singmin