#1
|
|||
|
|||
Possible to automate a list of words/phrase replacement with VBA?
Hi,
I've just come across VBA today. It's completely new to me. I want to ask for your opinion whether it's worthwhile to invest the time to learn VBA for the purpose that I'm doing. I do a lot of text translation from a foreign language to English. And once it's machine translated into English, the clean up process begins. Word and phrase replacement is a laborious part of it. There are thousands of short phrases that I need to replace. For example: The car red is parking --> The red car is parking. I have a master list of thousands for those replaceable phrases that I kept for all my translation. Right now, I'm using the "Find & Replace" dialogue in Word to replace each of those phrases one at a time. It's a painstaking process. I'm wondering whether VBA script can be used to find & replace each of those phrases from the master list automatically? If VBA can do that, then I want to spend time learning the language so I can do my job more efficiently. All advice is welcome. Cheers. |
#2
|
||||
|
||||
See, for example:
https://www.msofficeforums.com/word-...tween-two.html https://www.msofficeforums.com/word-...d-replace.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
If you don't want to spend the time learning VBA, investigate
https://www.gmayor.com/document_batch_processes.htm and its Find and Replace table pairs option.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find (highlight) two and more words in a list of 75k single words in Word 2010 | Usora | Word | 8 | 05-29-2018 03:34 AM |
Multiple words replacement | Kenjy | Word VBA | 2 | 04-02-2018 10:16 AM |
Find only the first Instance of Words -Then Do Replacement | dan88 | Word VBA | 6 | 05-15-2016 06:30 AM |
VBA: Replacement of words based on a list | roderh | Excel Programming | 2 | 09-06-2015 08:54 PM |
Automatic Words replacement | psychologist | Word VBA | 3 | 11-22-2014 11:40 AM |