?
Solved

How to change a class reference in multiple documents at once

Posted on 2009-07-03
2
Medium Priority
?
138 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Berkson Wein earned 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Suggested Courses

762 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