check properties of 400 Excel files

[Mark]

I have 400 Excel files that I wish to check the properties of.
Is there a way of checking them in bulk?

Perhaps a macro that will print the details of each file, or better still
send the details to a file.
The preferred data would be: Title, Author, Created, modified, last saved
by.

Regards, Mark

 

[Jezebel]

Yes, a macro would be a good approach. You're surely not posting the message
in the hope that someone will write it for you?

 

[David Sisson]

While you might get better response in the Excel programming group,
here's a start.
http://www.cpearson.com/excel/docprop.htm
http://word.mvps.org/FAQs/MacrosVBA/PrintAllDocsInFldr.htm
http://word.mvps.org/faqs/macrosvba/ReadFilesIntoArray.htm

 

[Helmut Weber]

Hi Mark,

http://support.microsoft.com/kb/224351/EN-US/

Greetings from Bavaria, Germany

Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/