Fog Creek Software
Discussion Board




Automate Changes to MS Doc Properties

My company went through a name change a while back, and we have thousands of .doc, .xls and .ppt that reflect the old name in the Document Properties (the tabbed dialog that appears when you select File... Properties from any MS Office doc).

The data in the Summary tab is used by some search engines, and is often displayed in the search results. Not good for us, since this data is often incorrect.

Anyone know of a method or tool to automate or speed-up the changing of these properties? E.g., I have a directory with 350 MS Word docs (Word 2000) -- how might I quicly change the company field on all of them from ABC Corp. to DEF Inc.? All files are in Office 2000 format, on Win2k.

Thanks in advance for any suggestions.

Baggaridim
Sunday, March 16, 2003

I suppose, these properties must be available through the office object model. So it should be possible to loop through a set of documents and update the values with  a simple vbs or VBA script

yg
Sunday, March 16, 2003

You might try doing something with this ActiveX utility, supplied by Microsoft:

http://support.microsoft.com/?kbid=224351

Herbert Sitz
Sunday, March 16, 2003

Thanks, those look like good suggestions.
O if only we were dealing with an open, non-binary (preferably XML) format.

Baggaridim
Sunday, March 16, 2003

drop me a line and i'll email you some vb code that can do that with word docs -- should be easy to change for excel, etc.
it also can attach new doc templates (styles, etc.) and a few other things.

Bill
Monday, March 24, 2003

*  Recent Topics

*  Fog Creek Home