![]() |
|
#1
|
|||
|
|||
|
I am not a coder. I've into a problem with a colleague after walking him through installation of a macro over the phone.
When he runs it, he's getting a message of a compile error and "Method or data member not found." In VB, the first line, with the macro name, is highlighted with a yellow pointer, and teh line ".NumberSpacing = wdNumberSpacingDefault" is highlighted in blue. He is using Word 2007. Could this be a compatibility error? Here is the code: Code:
Sub EIRPreEdit()
'
' Macro to format the entire document to Times New Roman 14 pt 6/6, single space, left-aligned
' replace straight single and double straight quotes with curly, and transpose commas and periods to inside of close quote
' remove tabs;
' replace two or more consecutive character spaces with a single one
' replace manual line returns with hard returns; and
' remove empty paragraphs
'
'
Selection.WholeStory
With Selection.Font
.Name = "Times New Roman"
.Color = wdColorAutomatic
.Size = 14
.Spacing = 0
.Scaling = 100
.Position = 0
.Kerning = 0
.NumberSpacing = wdNumberSpacingDefault
.NumberForm = wdNumberFormDefault
.StylisticSet = wdStylisticSetDefault
.ContextualAlternates = 0
With Selection.ParagraphFormat
.LeftIndent = InchesToPoints(0)
.RightIndent = InchesToPoints(0)
.SpaceBefore = 6
.SpaceBeforeAuto = False
.SpaceAfter = 6
.SpaceAfterAuto = False
.LineSpacingRule = wdLineSpaceSingle
.Alignment = wdAlignParagraphLeft
.Hyphenation = True
.FirstLineIndent = InchesToPoints(0)
.OutlineLevel = wdOutlineLevelBodyText
.CharacterUnitLeftIndent = 0
.CharacterUnitRightIndent = 0
.CharacterUnitFirstLineIndent = 0
.LineUnitBefore = 0
.LineUnitAfter = 0
.CollapsedByDefault = False
End With
With Selection.Find
.Text = "^t"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindStop
.Format = False
Selection.Find.Execute Replace:=wdReplaceAll
Selection.MoveLeft Unit:=wdCharacter, Count:=1
.Text = "'"
.Replacement.Text = "'"
.Forward = True
.Wrap = wdFindContinue
Selection.Find.Execute Replace:=wdReplaceAll
.Text = """"
.Replacement.Text = """"
.Forward = True
.Wrap = wdFindContinue
Selection.Find.Execute Replace:=wdReplaceAll
.Text = ""","
.Replacement.Text = ","""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchWildcards = False
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "',"
.Replacement.Text = ",'"
.Forward = True
.Wrap = wdFindContinue
.Format = False
Selection.Find.Execute Replace:=wdReplaceAll
.Text = """."
.Replacement.Text = "."""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchWildcards = False
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "'."
.Replacement.Text = ".'"
.Forward = True
.Wrap = wdFindContinue
.Format = False
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "[^l]{1,}"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchWildcards = True
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "--"
.Replacement.Text = "^+"
.Forward = True
.Wrap = wdFindContinue
.Format = False
Selection.Find.Execute Replace:=wdReplaceAll
.Format = False
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = False
.Replacement.Text = "^+"
.Text = " ^+"
.Execute Replace:=wdReplaceAll
.Text = "^+ "
.Execute Replace:=wdReplaceAll
.Text = "[^s]{1,}"
.Replacement.Text = " "
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = True
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "[^13]{2,}"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = True
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "([^13] [^13]){1,}"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = True
Selection.Find.Execute Replace:=wdReplaceAll
.Text = "[ ]{2,}"
.Replacement.Text = " "
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = True
Selection.Find.Execute Replace:=wdReplaceAll
End With
End With
End Sub
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Compile error on hidden module | Simss | Excel Programming | 2 | 09-25-2017 01:37 AM |
| compile error expected end sub | ashg75 | Word VBA | 2 | 07-13-2017 07:08 AM |
Compile error in Module
|
ksigcajun | Word VBA | 2 | 04-08-2015 06:44 AM |
| Compile error: sub or function not defined.. | xena2305 | Excel Programming | 0 | 08-02-2011 10:17 AM |
| compile error in Word | raco | Word | 0 | 09-28-2010 12:40 PM |