Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2020, 10:53 PM
i.am.jukebox.two i.am.jukebox.two is offline Possible to automate a list of words/phrase replacement with VBA? Windows 10 Possible to automate a list of words/phrase replacement with VBA? Office 2019
Novice
Possible to automate a list of words/phrase replacement with VBA?
 
Join Date: Feb 2020
Posts: 1
i.am.jukebox.two is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-15-2020, 02:23 AM
macropod's Avatar
macropod macropod is offline Possible to automate a list of words/phrase replacement with VBA? Windows 7 64bit Possible to automate a list of words/phrase replacement with VBA? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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-...tween-two.html
https://www.msofficeforums.com/word-...d-replace.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-15-2020, 05:13 AM
gmayor's Avatar
gmayor gmayor is offline Possible to automate a list of words/phrase replacement with VBA? Windows 10 Possible to automate a list of words/phrase replacement with VBA? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
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 of
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Possible to automate a list of words/phrase replacement with VBA? Multiple words replacement Kenjy Word VBA 2 04-02-2018 10:16 AM
Possible to automate a list of words/phrase replacement with VBA? Find only the first Instance of Words -Then Do Replacement dan88 Word VBA 6 05-15-2016 06:30 AM
Possible to automate a list of words/phrase replacement with VBA? VBA: Replacement of words based on a list roderh Excel Programming 2 09-06-2015 08:54 PM
Possible to automate a list of words/phrase replacement with VBA? Automatic Words replacement psychologist Word VBA 3 11-22-2014 11:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 AM.


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