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

"Lance" wrote in message
...
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!