I want to list (from a known directory eg: E:\Customers)
the folder names (that branch off the Customers folder)
into sheet1 and filenames in each folder into sheet2. Can
this be done with VBA or do I need to resort to an API
call?
If anyone knows or has an idea, let me know here and at my
email:


Alternatively,
In vb6 there is a control that lists all the files in a
given directory, in a listbox. Is there a similar control
in excel?

Could I use this control in excel? I've got it but haven't
tried it yet.

regards
Mark