Macro that can search folder structure

I may be asking for something Excel cannot do but i thought i would ask. I would like a macro that can take a folder name that i input into a cell and do a search for it starting at N:\ and when it finds it , it displays the complete folder structure in a seperate cell . i attached a file whith instructions that i think better explains what i am looking for it to do.

Thanks,

See if the attached file works for you.

Does that help?

Note: I replaced the attachment with version 1a, which includes a returned value of "Not found" if the search target does not exist.

Hi,

Try the following macro

Please Login or Register  to view this content.