How to Search Microsoft VBA & VBScript Articles by Keyword

Last reviewed: October 20, 1997
Article ID: Q175197

The information in this article applies to:

Microsoft Visual Basic for Applications version 5.0
Microsoft Access versions 7.0, 97
Microsoft Excel for Windows, versions 5.0, 5.0a, 5.0c
Microsoft Excel 97 for Windows
Microsoft FrontPage 97 for Windows
Microsoft FrontPage 98 for Windows
Microsoft Outlook 97
Microsoft PowerPoint 97 for Windows
Microsoft Word 97 for Windows

SUMMARY

You can use keywords to easily query for specific topics in the Microsoft Knowledge Base. This article contains a list of the keywords specifically for Microsoft Visual Basic for Applications (VBA) and Microsoft Visual Basic Scripting Edition (VBScript) articles. By using these keywords, you can quickly access common topics.

MORE INFORMATION

The keywords are grouped below under the following headings:

   Keywords Used in Titles
   Keywords (General and Product-specific)
   Product-specific Keywords
   Additional Query Words

Keywords Used in Titles

When you query the Microsoft Knowledge Base, you may get multiple articles in the query results. To quickly identify which products an article applies to, we have added a product-specific prefix to the titles of articles that apply to Microsoft desktop applications, such as the Microsoft Office programs.

If an article is about a programming topic that applies to any product that supports VBA or VBScript, the title will contain one of the following prefixes:

   VBA    Articles that apply to multiple versions of VBA
   VBS    Articles that apply to multiple versions of VBScript

If an article is about a programming topic that is specific to the interface or object model of a specific Microsoft product, the title will contain a prefix that designates that product.

   ACC    Articles that apply to multiple versions of Microsoft Access
   XL     Articles that apply to multiple versions of Microsoft Excel
   FP     Articles that apply to multiple versions of Microsoft FrontPage
   WD     Articles that apply to multiple versions of Microsoft Word
   OL     Articles that apply to multiple versions of Microsoft Outlook
   PPT    Articles that apply to multiple versions of Microsoft PowerPoint

If an article applies to a single version of a Microsoft product, the version number also appears in the prefix. For example, WD97 is the prefix for articles that apply only to Word 97.

Keywords (General and Product-specific)

Every article in the Knowledge Base has at least one general keyword, and may have other product-specific keywords that indicate the usage topic of the article. The keywords are located at the bottom of an article below the Additional Query Words line.

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q94671
   TITLE     : Categories and Keywords for All Knowledge Base Articles

Product-Specific Keywords

The following is a list of specific keywords used in VBA and VBScript articles.

   Topic                                       Keyword
   ---------------------------------------------------------

   Data, General                               DataOtherGnrl
   ISAM, General                               IsmGnrl
   Jet, Compact or repair                      JetCmp
   Jet, Data entry/editing                     JetDE
   Jet, Filters                                JetQryFiltr
   Jet, Find methods                           JetFind
   Jet, How to                                 JetQryHowto
   Jet, Multiuser/Locking                      JetMU
   Jet, Parameters/Referencing                 JetQryParm
   Jet, QueryDefs                              JetQryDef
   Jet, Recordsets                             JetRS
   Jet, Requery/Refresh                        JetRqry
   Jet, Security                               JetSec
   Jet, Transactions                           JetTrans
   Jet, Using bookmarks                        JetBkmk
   Jet, Validation                             JetValid
   ODBC, General                               ODBCGen
   ODBC, SQL data definition query             ODBCDDL
   ODBC, SQL pass-through query                ODBCSPT
   Automation, General                         AutoGnrl
   Automation, Graph                           AutoGrph
   Automation, Office Assistant                AutoOA
   Conversion, Difference between versions     CnvDif
   Conversion, General                         CnvGnrl
   Conversion, Problems                        CnvProb
   Documentation/Samples, Help                 DcmHlp
   Documentation/Samples, Manuals              DcmMnl
   Documentation/Samples, NWIND                DcmNwd
   Documentation/Samples, Samples              DcmSmp
   Environment/Config., GP Fault               EvnGpf
   Environment/Config., Hardware               EvnHdwr
   Environment/Config., Networks               EvnNtw
   Environment/Config., Operating system       EvnOs
   Environment/Config., Other                  EvnOthr
   General, Help compiler                      GnrlHC
   General, VB compatibility                   GnrlVb
   Interoperability, Custom controls           IntpCstm
   Interoperability, DDE                       IntpDde
   Interoperability, Mail                      IntpMail
   Interoperability, Menus                     IntpMenu
   Interoperability, Other                     IntpOthr
   Interoperability, Print or mail merge       IntpPrtm
   Interoperability, Shell to other apps       IntpShell
   Interoperability, Toolbars                  IntpToolbr
   Optimization, Memory management             OptMemMgt
   Optimization, Performance                   OptPrfm
   Programming, API/DLL calls                  PgmApi
   Programming, Class modules                  PgmCM
   Programming, Controlling printing options   PgmPrt
   Programming, Declarations/Dim               PgmDecl
   Programming, Events                         PgmEvnt
   Programming, File manipulation              PgmFilem
   Programming, How to                         PgmHowto
   Programming, Looping structures             PgmLoop
   Programming, Other                          PgmOthr
   Programming, Parsing strings and files      PgmParse
   Programming, Performance/Optimization       PgmPrfm
   Programming, Reserved words                 PgmRsvd
   Programming, Standard controls/forms        PgmCtrlsStd
   Programming, Variables                      PgmVbl
   Programming, Working with collections       PgmColl
   Syntax/Formulas, Functions                  SynFnc
   Syntax/Formulas, General                    SynGnrl
   Syntax/Formulas, Referencing                SynRef
   VBE/Debugging, Debug window                 DBugDebugW
   VBE/Debugging, Error handling/debugging     DBugErrHand
   VBE/Debugging, References                   DBugRefs
   Programming, General                        ScriptGnrl
   Programming, How to                         ScriptHowTo

Additional Query Words

Words in the Additional Query Words line at the end of an article include the following:

Acronyms (such as GPF, MOM, DAL, DAM, ODBC, ATP, OSBP, SBFM).
Alternate spellings or word choices (such as addin, tool pack, hang crash, lock up, freeze, won't respond, interop).
Words that do not appear in the article that you might use to find the article.

Keywords          : kbkeyword
Version           : WINDOWS:5.0,5.0a,5.0c,7.0,97
Platform          : WINDOWS
Issue type        : kbkeyword

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 20, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.