Thread: Spelling Macro
View Single Post
Old 11-30-2008, 04:18 AM   #1
PieOPah
Addict
PieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-booksPieOPah has learned how to read e-books
 
PieOPah's Avatar
 
Posts: 398
Karma: 914
Join Date: Oct 2008
Location: UK
Device: Sony PRS-505
Spelling Macro

I am currently trying to write a macro to convert US spelling to UK

I have something like this -

Code:
Sub Spelling()
'
' Spelling Macro
' Macro recorded 29/11/2008 by Simon Argent
'
    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "color"
        .Replacement.Text = "colour"
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll

    With Selection.Find
        .Text = "flavor"
        .Replacement.Text = "flavour"
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
Is there a more efficient way of doing this - or is there already a macro available I can use?

Many thanks,
PieOPah is offline   Reply With Quote