Re: [ExcelVBA] Using Excel VBA to generate an archive of document metadata

Could you include a dummy macro to open each file then I will modify the
appropriate line for the right field name

Many thanks

Dr B
On 15 Feb 2013 17:10, "Paul Schreiner" <schreiner_paul@att.net> wrote:

> 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]
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]



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

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

----------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ExcelVBA/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ExcelVBA/join
(Yahoo! ID required)

<*> To change settings via email:
ExcelVBA-digest@yahoogroups.com
ExcelVBA-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
ExcelVBA-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/