Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2013, 05:34 AM
redhin redhin is offline Highlight and then replace multiple words Windows 7 32bit Highlight and then replace multiple words Office 2010 32bit
Novice
Highlight and then replace multiple words
 
Join Date: Mar 2013
Posts: 4
redhin is on a distinguished road
Default Highlight and then replace multiple words

Hi Friends,



I have 300 documents, each of which has to be checked for around 500 different 'customer names'. After highlighting the occurances I wish to check them for correctness visually and then replace all of them with one single word.
Please help me...
Reply With Quote
  #2  
Old 03-04-2013, 06:43 AM
redhin redhin is offline Highlight and then replace multiple words Windows 7 32bit Highlight and then replace multiple words Office 2010 32bit
Novice
Highlight and then replace multiple words
 
Join Date: Mar 2013
Posts: 4
redhin is on a distinguished road
Default A maximum of how many words can be searched for at a time?

A maximum of how many words can be searched for at a time?

I tried to use a macro for finding some 500 different words from a document. But after adding around 80 words the rest could not be added. Is there any limit for this?

Please help....
Reply With Quote
  #3  
Old 03-04-2013, 06:58 AM
macropod's Avatar
macropod macropod is offline Highlight and then replace multiple words Windows 7 64bit Highlight and then replace multiple words Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,938
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

For some code to do the interactive part, see: https://www.msofficeforums.com/word-...html#post31849

For some code for the multi-document part, see: https://www.msofficeforums.com/word-...cel-range.html

With the Excel workbook approach, there is no practical limit to the # of words that can be searched for (the real limit in the above implementations is 1,048,576 search terms, but only because the macros aren't coded to work with more than one column of search terms ...).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 03-04-2013, 10:53 PM
redhin redhin is offline Highlight and then replace multiple words Windows 7 32bit Highlight and then replace multiple words Office 2010 32bit
Novice
Highlight and then replace multiple words
 
Join Date: Mar 2013
Posts: 4
redhin is on a distinguished road
Default

Hi Paul,

Thanks for heping me.
But, what do you mean by "Excel workbook approach"?
I have to search for 500+ search terms....

Regards,
Redhin
Reply With Quote
  #5  
Old 03-04-2013, 11:11 PM
macropod's Avatar
macropod macropod is offline Highlight and then replace multiple words Windows 7 64bit Highlight and then replace multiple words Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,938
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

I mean that by using an Excel workbook to hold the search terms, as the code in the links portray. Even without using Excel, I've contstructed a Find/Replace macro in the past with over 1500 words - all embedded in one long string in the macro.

The F/R macro with the first 1500 words can be downloaded from: http://windowssecrets.com/forums/sho...118394-Globish
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 03-05-2013, 05:42 AM
redhin redhin is offline Highlight and then replace multiple words Windows 7 32bit Highlight and then replace multiple words Office 2010 32bit
Novice
Highlight and then replace multiple words
 
Join Date: Mar 2013
Posts: 4
redhin is on a distinguished road
Default

Hi Paul,

I am really amazed....You are really great.......It works wonderfully.....I have replaced the list of 'Goblish' words with the 'customer name'.....
..And it's suddenly.... "the impossible has become possible....."
...I just don't know how to thank you.....

Thanks.....Thanks a million...God bless you....

Regards,
Radhin
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight and then replace multiple words Find and highlight multiple words in MS Word document AtaLoss Word VBA 37 09-22-2021 12:04 PM
Highlight and then replace multiple words How to make it highlight blocks of text (words) without highlighting extra space @end seortm Word 3 03-30-2015 08:12 AM
Highlight and then replace multiple words Find and highlight all words ending in -ly RBLampert Word VBA 13 10-23-2012 04:45 PM
Highlight and then replace multiple words Macro to replace few words in the document ubns Word VBA 7 08-16-2012 10:33 PM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 PM.


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