Hi

I am trying to create a Macro that returns to a spreadsheet a list of names
of sub-directories within a particular directory.

For example, I am trying to return a list of company names within my sales
team directory

eg.

R:\Team 318\ **** my sales team:)
\ACME
\TOYOTA
\GM

would return....

ACME
TOYOTA
GM

Any hints?

Regards

Andy