File List Generator?

[Moonshine]

Hi

We're doing a major clean up of our network drives here, we one folder with nearly 2500 files in it, of all breed's (xls, doc, mdb, you name it we have it)

What we'd like to do, is generate a list that will have the following info in it.

File Name
Location
Size
Owner/Created By
Date last Modified


All of these files are seen in Windows Explorer, but can you get to them via VBA?

 

[namliam]

You might do: Dir/S >C:\MyFiles.txt

in a dos box. This will list everything you need to know in a text file. Then mine the textfile.... using the line input, open,close commands...

I suppose there are better ways... but this is one....

Regards

The Mailman

 

[Moonshine]

Thanks for that..

But it doesnt get the Owner/Creator of the file, which is the main part we are after

 

[Opengrave]

Not exactly VBA but maybe even simpler. Try the DOS command DIR with some switches (to get more info on DIR switches type HELP DIR at the dos prompt). You can output the whole directory structure to a text file then import to a table or to do additional processing. For starters try:
dir /Q /S >C:\filename.txt

I know it is not exactly what you want but it might help.

 

[Opengrave]

Doh! Simulpost...
The /Q switch gets you the owner.