Pulling Out Spelling Errors

Summary: Unless you are creating a very short document, chances are good that your prose will contain spelling errors. If you want to collect all those spelling errors in a single place, you'll find the macro in this tip to be invaluable. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

Word includes a power spellchecker that allows you to determine which words in a document need your attention. Sometimes, it might be helpful to have all the misspelled words in one place, rather than throughout the document. If you have this need, the following VBA macro will gather all the misspelled words from one document and place them in a new document.

Sub GetSpellingErrors()
    Dim DocThis As Document
    Dim iErrorCnt As Integer
    Dim J As Integer

    Set DocThis = ActiveDocument
    Documents.Add

    iErrorCnt = DocThis.SpellingErrors.Count
    For J = 1 To iErrorCnt
        Selection.TypeText Text:=DocThis.SpellingErrors(J)
        Selection.TypeParagraph
    Next J
End Sub

Tip #1465 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Tremendous Table Tips! We often take tables for granted, but Word includes some very powerful ways you can present your tabular data. Discover how to make your tables better, easier to understand, and more effective.

Check out WordTips: Terrific Tables today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Pulling Out Spelling Errors