Home |
Search |
Today's Posts |
#1
|
|||
|
|||
check properties of 400 Excel files
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 |
#2
|
|||
|
|||
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? "Mark" wrote in message ... 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 |
#3
|
|||
|
|||
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/...DocsInFldr.htm http://word.mvps.org/faqs/macrosvba/...sIntoArray.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
How to check for dupes on 2 files, and ? about csv file ext | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
How can I compare the contents of two Excel files? | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |