VBA macros

macropod · #1 07-19-2011, 12:16 AM

Hi tays01s,

Since the macro recorder apparently captured your 'email' sub, I doubt using a trial version has anything to do with it (unless, perhaps, the trial period has expired).

For a recorded Find/Replace macro, you should see code like:

Code:

Sub Macro1()
'
' Macro1 Macro
'
'
  Selection.Find.ClearFormatting
  Selection.Find.Replacement.ClearFormatting
  With Selection.Find
    .Text = "some text"
    .Replacement.Text = "^&"
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchAllWordForms = False
    .MatchSoundsLike = False
    .MatchWildcards = True
  End With
  Selection.Find.Execute Replace:=wdReplaceAll
End Sub

If you care to describe what you're trying to achieve, I might be able to provide you with something far more efficient than what the macro recorder will give you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macros	nore	Outlook	0	06-01-2011 04:39 PM
Macros	Steveg	Word VBA	0	08-18-2010 04:04 PM
Macros	Desertwrangler	Word VBA	6	06-25-2010 07:06 AM
macros	trancetheory	Outlook	0	05-11-2010 09:31 AM
Macros	krdzal	Excel	1	04-06-2010 07:43 AM