[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

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___