bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Spelling and Grammar Checking > Exclusion Lists > Updating the Spelling Exclusion List Automatically with WordBasic

Updating the Spelling Exclusion List Automatically with WordBasic

Summary: Word allows you to create an exclusion list for the spell checker. Here's a WordBasic macro that updates the exclusion list automatically. (This tip works with Microsoft Word 6, and Word 95.)

If you find yourself updating the spelling exclusion list quite a bit, it can be a bother to always load the file, add the word, and then resave and close the file. When you are using custom dictionaries, Word allows you to add a word to them by a click of a button. There is no such simple approach, however, when it comes to the exclude list.

The following macro will allow you to quickly add a word to the exclude list. You can assign this macro to a button on the toolbar, and then you can update the list by simply highlighting a word and then clicking on the button:

Sub MAIN
    OldDir$ = DefaultDir$(0)
    AddWord$ = RTrim$(Selection$())
    AddWord$ = LTrim$(AddWord$)
    ChDefaultDir \
        "C:\Program Files\Common Files\Microsoft Shared\Proof\", 0
    ' Note that the file name in the next line should be changed so it
    ' reflects the proper exclude file name for your system
    FileOpen .Name = "Mssp2_en.exc", .ConfirmConversions = 0, \
        .ReadOnly = 0, .AddToMru = 0, .PasswordDoc = "", \
        .PasswordDot = "", .Revert = 0, .WritePasswordDoc = "", \
        .WritePasswordDot = ""
    Insert AddWord$
    InsertPara
    FileClose 1
    ChDefaultDir OldDir$, 0
End Sub

This macro "cleans up" the selected word in your document and then adds it to the beginning of the exclude file. You will see a quick flash on your screen as the exclude file is loaded, modified, and then closed, but the word is then available in the exclude file for when you use Word in the future.

You should make sure that you change the name of the file being used for the exclude file. The name of the file can vary from system to system.

Tip #1188 applies to Microsoft Word versions: 6 | 95


Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.
 
Check out WordTips Premium today!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)