• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

How to change a class reference in multiple documents at once


I was wondering how you can change a class reference in a Microsoft Word document, in my case hundreds, without having to go through each document and manually change it one by one?

Currently there are numerous documents that I have linked to a class that I created to automate adding a signature to the bottom.  Basically it is reference via: \\server\folder\file and we have recently switched our server to a newer model.  The server name was FS-03 and is now FS-04, so when people try to run these documents it doesn't run the code in the class that is supposed to be referenced.

Any help would be greatly appreciated.


1 Solution
Berkson WeinTech FreelancerCommented:
Next time, I'd try using a central repository for the code, that updates each pc.  Then don't have the code stored in the 100's of word documents, but have the code run from a single updateable file.  Will be much easier to maintain.
 To use VBA to edit VBA code, you need to use the VBA Extensibility feature.  Detailed information is here: http://www.cpearson.com/excel/vbe.aspx
The page has an example of finding text, but not replacing.  You should be able to modify that code to do a replace, then save, then move on to the next file.  
I don't know where or how these 100's of files are stored, but you might consider listing them all in a text document to make it easier for yourself to iterate through them all.
Another option might be to hack each file using a hex editor, searching for the FS-03 text and replacing it with FS-04.
Hope this helps.
agilebizAuthor Commented:
Had to go through each individually but the info you provided helped.  Set up a centrol location for the code so any changes (ie. new server) we wont need to modify the references.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now