![]() |
|
![]() |
|
Thread Tools | Display Modes |
#16
|
|||
|
|||
![]()
Thanks!
![]() |
#17
|
|||
|
|||
![]()
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. |
#18
|
||||
|
||||
![]()
The first of those modifications would make the code run dramatically slower. Do you really need a 493-character definition?
As for the second issue, you could try changing: .Text = "(" & Split(Split(FRList, vbCr)(j), vbTab)(0) & ")" .Replacement.Text = "^&-" & Split(Split(FRList, vbCr)(j), vbTab)(1) to: .Text = "(" & Split(Split(FRList, vbCr)(j), vbTab)(0) & ") (" .Replacement.Text = "(" & Split(Split(FRList, vbCr)(j), vbTab)(0) & ")-" & Split(Split(FRList, vbCr)(j), vbTab)(1) & " ("
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
|||
|
|||
![]()
I will try your recommendation for the second issue soon while for the first issue if I know the maximum character limit that can be accommodated then I can take out the large definitions. What is the maximum character limit? Thanks
|
#20
|
||||
|
||||
![]()
IIRC, the limit is 255 characters for the total length of the expression. In this case, because the Find expression & brackets are part of the replacement expression, that has to be deducted from the 255 characters.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#21
|
|||
|
|||
![]()
Yeah that worked! Thanks! That is so awesome. 1 small thing: Is there a quick way to insert a right square bracket ] after every bold word in a document?
I asked MS Word to find the bold word and replace with ^&] but it entered the ] after a tab. |
#22
|
||||
|
||||
![]() Quote:
^t Then, for the Replace expression, use: ]^t
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#23
|
|||
|
|||
![]()
Thank you very much
Last edited by Singh_Edm; 09-19-2014 at 03:23 PM. Reason: Acknowledged contribution. |
![]() |
Tags |
macro find and replace, macro vba word, macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
Won't find in search | ep2002 | Word | 3 | 10-31-2012 05:24 PM |
![]() |
jperez84 | Word VBA | 10 | 09-19-2012 04:48 PM |
![]() |
Jamal NUMAN | Word | 2 | 06-26-2011 09:49 AM |
Search Replace Copy | dblack7211 | Word | 0 | 05-05-2010 01:19 PM |