![]() |
|
#1
|
|||
|
|||
|
Hello
With the help of some AI bots, the Word macro below was generated to use regex in Find and Replace with a YesNoCancel prompt (macro runs from cursor position). The problem with this macro is that when the Find string and Replace string are not of the same length, the first replacing is done correctly, but then the other search results are incorrectly selected, and no replacing is showing. AI bots are suggesting updating cursor position, but all their solutions don't work! Any help is much appreciated. PS: The pattern and replacementtext in the macro below are just examples. I need the macro for cases that are not supported by wildcards. Here's the macro: Code:
Sub PromptRegExReplace()
Dim regEx As Object
Dim match As Object
Dim matches As Object
Dim rng As Range
Dim response As Integer
Dim replacementText As String
Set regEx = CreateObject("VBScript.RegExp")
regEx.Pattern = "([0-9])"
regEx.Global = True
' Get the current cursor position
Dim cursorPosition As Long
cursorPosition = Selection.Start
' Set the range to start from the cursor position until the end of the document
Set matches = regEx.Execute(ActiveDocument.Range(cursorPosition, ActiveDocument.Range.End).text)
replacementText = "$1abc"
For Each match In matches
Set rng = ActiveDocument.Range(match.FirstIndex + cursorPosition, match.FirstIndex + match.Length + cursorPosition)
rng.Select
response = MsgBox("Replace this instance?", vbYesNoCancel)
If response = vbYes Then
Application.ScreenUpdating = False
rng.text = regEx.replace(rng.text, replacementText)
Application.ScreenUpdating = True
ElseIf response = vbCancel Then
Exit Sub
End If
Next match
End Sub
|
| Tags |
| prompt, regex, replacing |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to keep a list of search results | Jedothek | Word | 2 | 08-19-2020 07:22 AM |
| 2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
Outlook search too many results
|
alexb123 | Outlook | 1 | 10-10-2013 09:53 AM |
| Search results disappearing | Emerogork | Office | 3 | 07-17-2011 03:52 PM |
| Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |