Dr. B.
It's pretty simple to parse through the folders and generate a list of file
names, path names and last modified times.
But getting the author's userid isn't quite so easy.
I'll throw together some code that will allow you to get the rest of the info,
but I THINK the only way to get it to give you the author is to have the macro
open each file.
Depending on the file type, there is probably parameters like:
wb.BuiltinDocumentProperties("Last author")
that would give you the last user name for Excel files.
I'll throw something together for the folder search.
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: Dr John C Bullas john.bullas@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Fri, February 15, 2013 11:30:41 AM
Subject: [ExcelVBA] Using Excel VBA to generate an archive of document metadata
Good Afternoon/Morning/Evening!
I have a question for the forum:
I have a (very) large number of server directories with up to several
hundred files in each,
the majority of them are microsoft office generated documents
Is there a way to extract the
path / last modified / author
...fields in the document properties into a long spreadsheet to then
identify the main suspects and last
users of the directory tree via filters and or sorting of the spreadsheet
Many thanks in advance
(a bit lost where it comes to grubbing around in a servers undergarments)
Dr B
--
===========================
http://uk.linkedin.com/in/drjohnbullas
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar