Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2017, 04:16 AM
benpk1 benpk1 is offline Multiple find and replace Word 2016 Windows 7 64bit Multiple find and replace Word 2016 Office 2016
Novice
Multiple find and replace Word 2016
 
Join Date: Feb 2017
Posts: 3
benpk1 is on a distinguished road
Default Multiple find and replace Word 2016


Good Morning,

As a very rusty VBA person, I am looking for some support with a script that will:

Open multiple Word documents in multiple folder locations - all the files are within a folder hierachy, so selecting the top folder will work for my purposes if it applies to all subfolders.

Replace specific words in all the documents. I have a list of about 20 words that I need to replace with alternatives. The replacement words must match the case of the replacement word and not the case of the current word. No wildcards needed.

Save documents - no need to save in alternative place.

I can find scripts that almost do what I need, but would be grateful for any experts getting me the full way.

Thanks in advance.
Reply With Quote
  #2  
Old 02-28-2017, 04:27 AM
macropod's Avatar
macropod macropod is offline Multiple find and replace Word 2016 Windows 7 64bit Multiple find and replace Word 2016 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by benpk1 View Post
I can find scripts that almost do what I need, but would be grateful for any experts getting me the full way.
To which scripts are you referring and in what sense do they 'almost' do what you need?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-28-2017, 04:54 AM
benpk1 benpk1 is offline Multiple find and replace Word 2016 Windows 7 64bit Multiple find and replace Word 2016 Office 2016
Novice
Multiple find and replace Word 2016
 
Join Date: Feb 2017
Posts: 3
benpk1 is on a distinguished road
Default

Hi Paul,

I can find scripts that allow one word at a time over documents saved in the same folder, but where these fail is that I can't get the script to do multiple words or to automatically pick up all word documents in subfolders.

Thanks,

Ben
Reply With Quote
  #4  
Old 02-28-2017, 02:48 PM
macropod's Avatar
macropod macropod is offline Multiple find and replace Word 2016 Windows 7 64bit Multiple find and replace Word 2016 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example: https://www.msofficeforums.com/word-...html#post70765
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-28-2017, 09:39 PM
gmayor's Avatar
gmayor gmayor is offline Multiple find and replace Word 2016 Windows 10 Multiple find and replace Word 2016 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

See the use of table pairs at
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 03-01-2017, 02:41 AM
benpk1 benpk1 is offline Multiple find and replace Word 2016 Windows 7 64bit Multiple find and replace Word 2016 Office 2016
Novice
Multiple find and replace Word 2016
 
Join Date: Feb 2017
Posts: 3
benpk1 is on a distinguished road
Default

Thank you both for your useful replies. I think I'm sorted now.

Ben
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do multiple find and replace in string. PRA007 Word VBA 2 01-06-2016 09:10 PM
Find and Replace multiple table columns smakdown61 Word 1 08-28-2014 09:24 PM
Multiple find and replace Word 2016 How do I find/replace the same word in multiple documents? Ineedhelp! Word 3 03-04-2014 03:50 PM
Multiple find and replace Word 2016 How do I find and replace multiple items at once? redzan Word VBA 1 05-16-2013 08:25 AM
Multiple find and replace Word 2016 Find and Replace multiple lines/paragraphs jcw Word 1 11-18-2011 11:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft