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