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 <msing@mweb.co.za> 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