Wednesday, December 23, 2009

Word VBA – Avoid “There are too many spelling or grammatical errors in Document ...” message

When you are automating something in Word using VBA, the below message can be a nemesis. This message will wait for user input whereas you would have though the program will continue without user intervention.

To stop this message set the Grammar checked to be true

Sub Set_Spell_Grammar()

ActiveDocument.GrammarChecked = True

ActiveDocument.SpellingChecked = True

End Sub
Related Posts Plugin for WordPress, Blogger...
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.