Works great, except it comes back with subfolders...

3 Folders named EG1, EG2, and EG3, site in location...

X:/EXAMPLE/EXAMPLE/

there are furthur subfolders within eg1, eg2, and eg3.

how can i adjust this so the ONLY list that is displayed on th
worksheet is the original folder names... EG1, EG2, EG3

(obviously EG1,2,3 will change)

Is it possible to mask the location too?

As in all that shows in the sheet (folders) will be EG1,EG2, an
EG3...

no p:/EXAMPLE/EXAMPLE/

MANY THANKS AGAIN!

Antoni

--
aking198
-----------------------------------------------------------------------
aking1987's Profile: http://www.excelforum.com/member.php...fo&userid=1539
View this thread: http://www.excelforum.com/showthread.php?threadid=31375