Quote:

Actually I dont want the files, I need the folder names accurately at the 3rd level cos I need them for a CSV file ....etc
I need to put Folder level 1 in Column A, Folder Level 2 in Column B and Folder Level 3 in Column C.
I am of course doing this last minute now and rapidly funning out of time...



Well, if you'd tried the code sample I supplied you would have got a working solution straight away.

If you're viewing this board in threaded view be careful not to lose track of parallel threads or you might miss out on something important.