Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 09-16-2014, 09:11 AM
Singh_Edm Singh_Edm is offline Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1 Windows 8 Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1 Office 2013
Advanced Beginner
Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1
 
Join Date: Jan 2014
Posts: 41
Singh_Edm is on a distinguished road
Default

Hi macropod
I have 2 small issues.

1. I ran the code and got the following error: String parameter too long.
I clicked "debug" and the following line was highlighted.

.Replacement.Text = "^&-" & Split(Split(FRList, vbCr)(j), vbTab)(1)

It got stuck at the place where it had to insert meaning of a word whose length was 493 characters with spaces.

2. At some places in the document, the meanings are already inserted in blue after the red bracketed words. For e.g.

Australia is an awesome country. (Australia) (is) (an) (awesome) great, lovely, pleasant (country) (.)

Can a modification be made in the code so that when it is run and it finds the word (awesome), it inserts the meanings only if there is no text in blue immediately following the closing bracket.

Last edited by Singh_Edm; 09-16-2014 at 10:41 AM. Reason: Made my question clear.
Reply With Quote
 

Tags
macro find and replace, macro vba word, macros



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1 Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
Won't find in search ep2002 Word 3 10-31-2012 05:24 PM
Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1 Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
Find a word in doc1, search for it in dictionary doc2, copy the meaning from doc 2 to doc 1 where we can find the meaning for all the marks that Word uses? Jamal NUMAN Word 2 06-26-2011 09:49 AM
Search Replace Copy dblack7211 Word 0 05-05-2010 01:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 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