Foldername

[ajt0107]

Hi

I am in need of vb code which can list down the folder names of a prticular directory path. For example I have a folder "z" located at "c:\" with sub folders like "A", "B" etc and each of the subfolder has numerous files. I need a code which can list the folder names for me i.e. A, B etc on a spreadsheet.


Ajit Singh

[venkatpvc]

maybe

Please Login or Register  to view this content.

[jaslake]

Hi ajt0107

This Code written by Leith Ross will do as you describe

Please Login or Register  to view this content.

[Sean Thomas]

heres another one which asks for the folder first

Please Login or Register  to view this content.

[Leith Ross]

Hello Ajit,

This version of the macro allows you to choose the depth of subfolders to return. Passing a zero or no argument returns only the folders in the specified directory. Passing 1 will return the subfolders of each folder in the specified directory. A -1 will return all subfolders of subfolders. This uses only native VBA calls and is comtaible will all version of Excel.

Macro to ListFolders and Optionally Subfolders

Please Login or Register  to view this content.

Example of Using the Macro

Please Login or Register  to view this content.

P.S. John - Thanks for the credit.

[jaslake]

@Leith

You're "stuff" always amazes me...Credit where Credit is due.

I've not tested your new Code...didn't feel a need to...but it's in my toolbox.

[Leith Ross]

@ John,

Again, thanks. You are one of the few true gentleman remaining today.

Slainte agus sonas!
(May you be healthy and happy)

[jaslake]

@ Leith

Thanks for the kind words...my best to you and your Family.

Happy Holidays.