seems i jumped the gun a bit

i DO want a file listing INCLUDING the path

what i am actually trying to do is to find out the drawings i have for
certain buildings and they are all on a disk, folder names are the
buildings, and the parts of buildings that they belong to. FIle names
can be repetitive, so therefore need the folder names, ie full path.

can i get that in excel becuase the data is far more useful to me in
excel.

Thanks for Hector helping me before, sorry, now I need more.

TIA

Esra