Take a look at Jim Cone's fine commercial Add-in called ListFiles. It's
available at:
http://www.realezsites.com/bus/primitivesoftware/
Vaya con Dios,
Chuck, CABGx3
> i that to design a macro in excel file such that when i open the excel file
> the macro should read the names of all the folders present in 'my document'
> folder and paste those read folder names on workbook sheet.
>
> please help me out.