How to repeat a search followed by editing text?

Guessed · #1 08-23-2019, 05:37 PM

Since Greg's macro works by itself, you can choose an alternative approach to including it in your bigger macro - by using a pointer rather than the actual macro content.

Put Greg's macro in the same module as the larger macro. When you want Greg's macro to run, add a line in the bigger macro with the name of Greg's macro eg

Code:

Sub MyBigMacro()
  MsgBox "Working steps"
  ScratchMacro
  MsgBox "More working steps"
End Sub

Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
  Dim oRng As Range
  Set oRng = ActiveDocument.Range
  With oRng.Find
    .Text = "([a-z])(/)([a-z])"
    .MatchWildcards = True
    .Replacement.Text = "\1 \2 \3"
    .Execute Replace:=wdReplaceAll
  End With
lbl_Exit:
  Exit Sub
End Sub

If you step through that code, you can see that one macro runs a second macro. This is often used with Functions rather than Subs but the principle is the same.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
possible to repeat text with numbered list?	Burt	Word	5	07-14-2019 04:02 PM
outlook search tool locked with key word, it will not allow deleting or editing	roni	Outlook	0	07-12-2017 07:31 AM
Repeat text	dgame27	Word	1	07-06-2016 09:14 PM
Automatically Repeat Text in Footer	Luxanais	Word	2	09-24-2015 10:10 AM
Text will repeat in the fields	ypurcaro	Word	1	02-07-2013 01:46 AM