I have numerous Word documents in a folder with the string... "Jimmy" throughout them. I would like to enter the name "Bob" into an Excel cell, run a macro, and have it search and replace all occurrences of "Jimmy" with "Bob" in all Word documents in the folder. Can this be done?
Thx!
Last edited by Xx7; 02-27-2011 at 03:06 PM.
Hello Xx7,
This macro should do what you want. You will need to change the directory and the cell that will hold the search word to what you will be using
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith,
I believe a minor adjustment should possibly be made. I have the following Word docs in my target folder: "Document1", "Document2", "Document3"
When I run it, it gives an error message...
This file could not be found.
(C:Windows\system32\Document1.doc)
My target folder is: C:\Users\BD\Desktop\Folder
I'm assuming it's searching a different folder than expected?
Hello Xx7,
Try this version of the macro. You may want to change the FileType from ".doc" to ".docx". Otherwise it may try to open any Word document it finds.
Please Login or Register to view this content.
Beauty... it works! I just changed:
wdDoc.Close SaveChanges:=False
to
wdDoc.Close SaveChanges:=True
Last edited by Xx7; 02-27-2011 at 03:04 PM.
Final code:
Thanks Leith!!!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks