We have lots of drawings on our server, in various locations. WHilst many people can find them quickly, some that dont access them regularly spend ages looking for them.

How can I create a list of file names and their location?

Woul dbe handy if I could import this to excel or similar to sort alphebetically.

Would also be nice to put the file type in there too (*.dwg or *.pdf)

We have lots of drawings on our server, in various locations. WHilst many people can find them quickly, some that dont access them regularly spend ages looking for them.

How can I create a list of file names and their location?

Woul dbe handy if I could import this to excel or similar to sort alphebetically.

Would also be nice to put the file type in there too (*.dwg or *.pdf)

I gues it all depends if your staff all us the same drive letters.

if they all use the same drive letters you could goto a command prompt on a PC and type "dir *.pdf /s >pdf.txt" from the root of the drive letter. this will create a txt file with all pdf files found on that drive letter and their location. to change it to search for dwg change the command to "dir *.dwg /s >dwg.txt" you can change the text file to be any file name you like and you can also save it to a different file share.

This text file can be imported into excel in a matter of minutes.

Thanks, Matt.

Everyone uses "Z" as the root folder for the drawing locations.

Thats nearly what I'm after:

Directory of Z:\customer folder\MG-Rover

02/11/2004 17:55 44,747 TA750-M18.dwg

02/11/2004 17:34 45,179 WPN-C-B-ELK.dwg

2 File(s) 89,926 bytes

Except I'd like that to be in the format:

Filename1 Location

Filename2 Location

Rather than:

Location

Filename1

Filename2

Thanks, Matt.

Everyone uses "Z" as the root folder for the drawing locations.

the above should work fine then. any probs let me know

Matt - see my edited post above

Thanks, Matt.

Everyone uses "Z" as the root folder for the drawing locations.

Thats nearly what I'm after:

Directory of Z:\customer folder\MG-Rover

02/11/2004 17:55 44,747 TA750-M18.dwg

02/11/2004 17:34 45,179 WPN-C-B-ELK.dwg

2 File(s) 89,926 bytes

Except I'd like that to be in the format:

Filename1 Location

Filename2 Location

Rather than:

Location

Filename1

Filename2

dir /s /b

may be a bit closer to what you want....

Matt - see my edited post above

sorry Goochie, missed your edit. looks like sdenny has it spot on..