If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
File Properties Summary automation...
Hello:
I have a library of nearly 3000 files that I would like to add custom Summary metadata to...i.e., the "Title", "Subject", "Author", "Category", "Keywords", and "Comments" fields that are available in the Summary page of the file properties dialog. Is there a way to automate this process using batch files or scripting? Is there a freeware app available to do this? Thanks, Fred Schreck San Francisco, CA |
Ads |
#2
|
|||
|
|||
File Properties Summary automation...
Hi, Fred,
You need to adapt the code in the article http://www.mvps.org/word/FAQs/MacrosVBA/BatchFR.htm, which shows how to open, work on, and save/close each file in a directory. In place of the find & replace operations in that code, you need to set values for the various members of the BuiltInDocumentProperties collection -- see the VBA help topic about that collection. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://www.mvps.org/word Fred Schreck wrote: Hello: I have a library of nearly 3000 files that I would like to add custom Summary metadata to...i.e., the "Title", "Subject", "Author", "Category", "Keywords", and "Comments" fields that are available in the Summary page of the file properties dialog. Is there a way to automate this process using batch files or scripting? Is there a freeware app available to do this? Thanks, Fred Schreck San Francisco, CA |
#3
|
|||
|
|||
File Properties Summary automation...
Hi Fred,
If *all* you are wanting to read and change is the document properties of the various files, then you may be able to speed up this process by using techniques described in this article Getting access to the Document Properties of a Word file http://www.mvps.org/word/FAQs/MacrosVBA/DSOFile.htm That article includes a template you can download that will read the properties of a folder full of files and list them. However, it would only require a fairly small change to the code to set any properties you want to set. -- Regards Jonathan West - Word MVP MultiLinker - Automated generation of hyperlinks in Word Conversion to PDF & HTML http://www.multilinker.com "Jay Freedman" wrote in message ... Hi, Fred, You need to adapt the code in the article http://www.mvps.org/word/FAQs/MacrosVBA/BatchFR.htm, which shows how to open, work on, and save/close each file in a directory. In place of the find & replace operations in that code, you need to set values for the various members of the BuiltInDocumentProperties collection -- see the VBA help topic about that collection. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://www.mvps.org/word Fred Schreck wrote: Hello: I have a library of nearly 3000 files that I would like to add custom Summary metadata to...i.e., the "Title", "Subject", "Author", "Category", "Keywords", and "Comments" fields that are available in the Summary page of the file properties dialog. Is there a way to automate this process using batch files or scripting? Is there a freeware app available to do this? Thanks, Fred Schreck San Francisco, CA |
Thread Tools | |
Display Modes | |
|
|