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...

Visual Basic for Applications (VBA) Forum (recent threads)

CodeKeep VBA Feed

Visual Studio Tools for Office Forum (recent threads)

Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.

Office Business Applications (OBA) Team Blog

MSDN Code Gallery Published Resources For Tag VSTO

microsoft.public.vsnet.vstools.office Google Group