![]() |
|
|
|
#1
|
||||
|
||||
|
Try: Code:
Sub PromptReplace()
Dim Rng As Range, i As Long
Dim strFnd As String, strRpl As String
Dim fnd As String, rpl As String, choice As Integer
'find string
strFnd = "tot;tow;trail;contact;delivery;fist;form;latter;diffused;singed;sing;asset;tortuous;emotion;owning;statue;conversion"
'replace string in same order as strFnd
strRpl = "to;two;trial;contract;deliver;first;from;later;defused;signed;sign;assert;tortious;motion;owing;statute;conversation"
For i = 0 To UBound(Split(strFnd, ";"))
fnd = Split(strFnd, ";")(i)
rpl = Split(strRpl, ";")(i)
For Each Rng In ActiveDocument.StoryRanges
With Rng
With .Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = fnd
.Forward = True
.Wrap = wdFindStop
.Execute
End With
While .Find.Found
.Duplicate.Select
choice = MsgBox("Replace " & Chr(34) & fnd & Chr(34) & " with " & Chr(34) & rpl & Chr(34) & "?", _
vbYesNoCancel + vbDefaultButton1, "Replace")
If choice = vbYes Then
.Text = rpl
ElseIf choice = vbCancel Then
GoTo endit
End If
.Collapse wdCollapseEnd
.Find.Execute
Wend
End With
Next Rng
Next i
endit:
Set Rng = Nothing
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
|||
|
|||
|
Thank you. That seems to work perfectly. You revisions are very subtle, but it appears that the main difference is
Code:
.Duplicate.Select The other changes look like simple clean up stuff, though is moving the for each range... inside the for loop necessary... Never mind, I see now that it is. We need to set the ranges for each of the search pairs. |
|
| Tags |
| code |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Find, Replace
|
Ajay Shahane | Word VBA | 4 | 05-16-2012 04:07 AM |
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Is there a way to use "find/replace" to find italics words?
|
slayda | Word | 3 | 09-14-2011 02:16 PM |
Help with find and replace or query and replace
|
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
| User Name Prompt Appears When Opening Documents | galleherjazz | Office | 0 | 07-30-2009 08:15 PM |