while I have read number of threads in varies forums, I am not too sure how to proceed with my issues. My department is going to be asked to replace 1000 + documents in Word, Excel, PowerPoint and Visio 2007 the following;


(1) Old Job Titles with New Job Titles ( 40+ with varies spellings)
(2) replace number of our documents, which
(2a) require to change the title of the file name,
(2b) require to change all document which may refer to that particular file name.

However, also another issue is not all files are in one folder, there is some folders which have subfolder, after subfolder (we control documents and history of each revision, obviously historic documents will not wont to be changed);
(1) I will need to change files within subfolders also.

I do plan to have all the files that need to changed in on location which is separate from any historic files.

the idea I would like is to automate this process with little manual/ human interference as possible.

does anyone have a solution how to do this, either creating a VB application to open and replace the old_text with the new_text and old_doc_number replaced with new_doc_number in a doc and save it with the new_doc_number + doc_title.