The information in this article applies to:
SYMPTOMSWhen you use the WithEvents keyword to trap application events in Microsoft Word, you cannot trap the Quit event. CAUSEIf no documents are open when you quit Word, Word does not generate the Quit event. WORKAROUNDTo work around this problem, have your Visual Basic for Applications macro create at least one document prior to quitting Word. The document can be a blank, empty document. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONMicrosoft provides programming examples for illustration only, without
warranty either expressed or implied, including, but not limited to, the
implied warranties of merchantability and/or fitness for a particular
purpose. This article assumes that you are familiar with the programming
language being demonstrated and the tools used to create and debug
procedures. Microsoft support professionals can help explain the functionality
of a particular procedure, but they will not modify these examples to
provide added functionality or construct procedures to meet your specific
needs. If you have limited programming experience, you may want to contact
the Microsoft fee-based consulting line at (800) 936-5200. For more
information about the support options available from Microsoft, please see
the following page on the World Wide Web: http://www.microsoft.com/support/supportnet/refguide/ WithEvents is an optional keyword for the Dim, Private, and Public declaration statements. It is used to trap specific Application or ActiveX object events and is valid only in class modules. To create sample Visual Basic for Applications code that uses the WithEvents keyword, follow these steps:
NOTE: If no documents are open when you quit Word, the Quit event is not generated, and the message box is not displayed. For more information about Quit Event, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type "Quit Event" in the Office Assistant or the Answer Wizard, and then click Search to view the topic. For more information about WithEvents, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type "Public Statement" in the Office Assistant or the Answer Wizard, and then click Search to view the topic. For more information about using the sample code in this article, please see the following article in the Microsoft Knowledge Base: Q212536 OFF2000: How to Run Sample Code from Knowledge Base Articles REFERENCES
For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base: Q163435 VBA: Programming Resources for Visual Basic for Applications Additional query words: vba vb vbe
Keywords : kbcode kbprg kbdta OffVBA kbmacroexample kbwordvba wd2000 |
Last Reviewed: May 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |