copy knowledge needed

i have about 340 folders with content, all i want to do is copy the names of
the folders in to excel, and it will not allow me to, what am i doing wrong.
i was thinking i could just high lite all the folders and drag into excel and
it would automatically place just the names. help please
--
dddw!

Try this, Lance: http://vbaexpress.com/kb/getarticle.php?kb_id=781
************
Anne Troy
www.OfficeArticles.com

"Lance" <Lance@discussions.microsoft.com> wrote in message
news:126D5254-7C13-4356-A91D-FFDA58A93F5F@microsoft.com...
>i have about 340 folders with content, all i want to do is copy the names
>of
> the folders in to excel, and it will not allow me to, what am i doing
> wrong.
> i was thinking i could just high lite all the folders and drag into excel
> and
> it would automatically place just the names. help please
> --
> dddw!