Macro to list folder names within a directory

Hi guys,

Thanks for all the help recently but I am not yet done! Now i'm looking for a macro which within a sheet named "foldernamedump" will list in a column the folder names within a directory I specify.

I have seen a couple of sample codes but I just cant seem to get them working at all so I think its best to start from scratch and the work i get supplied here is always perfect.

I also want the macro to clear the contents of the sheet before it loads again just to ensure there is no old data within the sheet.

Thank you for any help

Hello munkee,

This macro will all the folders in a given directory. The list is output to the "Sheet1" starting in cell "A2". The folder name, path, and size are printed in the same row. You can change the directory, worksheet, and starting cell. They are all marked in red.

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Hello Mustang,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.