Solved

How to change a class reference in multiple documents at once

Posted on 2009-07-03
2
128 Views
Last Modified: 2012-05-07
Hi,

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.

Thanks,

Pat
0
Comment
Question by:agilebiz
2 Comments
 
LVL 15

Accepted Solution

by:
weinberk earned 500 total points
ID: 24774428
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.
 
0
 

Author Closing Comment

by:agilebiz
ID: 31599595
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.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now