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).
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
You might try doing something with this ActiveX utility, supplied by Microsoft:
Thanks, those look like good suggestions.
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.
Fog Creek Home