List of Folders

Good morning all,

I have an excel file that I am using to create an index. What I want to do is have excel list all of the folder names that are in the same directory as the excel file. I can get the full path name listed but not just the folder name. Any ideas?

Thanks in advance,
tc

Hello toocold,

Here is a macro that will list the directory your are searching in cell "A1" of the Active Sheet, and all the folder names in it starting at cell "A2".

Please Login or Register  to view this content.

Sincerely,
Leith Ross

thanks guys, works great

Hi

This will use the currently selected file, and put the output in the file with the macro. That way you don't have to put the macro into the file you are testing....

Please Login or Register  to view this content.

rylo