Differences Between VB 3.0 and Applications Edition

Last reviewed: July 29, 1997
Article ID: Q120362
The information in this article applies to:
  • Microsoft Visual Basic Programming System, Applications Edition, version 1.0

SUMMARY

The following information discusses differences between Microsoft Visual Basic Programming System, Applications Edition and Microsoft Visual Basic 3.0, Standard and Professional Editions.

MORE INFORMATION

In general, the Applications Edition of the Visual Basic Programming System helps you customize the applications that support it: Microsoft Excel and Microsoft Project. In contrast, Visual Basic 3.0 allows you to create independent applications.

Because the Applications Edition of Visual Basic must operate within an application that supports it, there are some differences in what you can and cannot control.

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

   ARTICLE-ID: Q113334
   TITLE     : Differences Between VB 3.0 Standard & Professional Editions

Dialog Box Controls

The Applications Edition in Microsoft Excel has a limited set of object properties for dialog box controls. You cannot format or align text, and the events that you can use for dialog box controls are limited to OnClick, OnChange, and OnShow. Visual Basic 3.0 events such as Focus, Keydown, and Mousedown are not available.

Database Connectivity

Using Visual Basic, Applications Edition in Microsoft Excel, limited database connectivity is supported through Microsoft Query. A feature in both the Standard and Professional Editions of Visual Basic is the Microsoft Access 1.1 Database Engine. The database engine provides direct access to Microsoft Access, Microsoft FoxPro, Borland dBASE, Borland Paradox, and Novell Btrieve. The Professional Edition offers full Open Database Connectivity (ODBC) support.

Using .VBX Files

You cannot use custom controls (.VBX files) with Visual Basic, Applications Edition. While .VBX files enhance the functionality of Visual Basic version 3.0, objects in Visual Basic, Applications Edition offer similar enhancements.

Visual Basic 3.0, Professional Edition provides .VBX files for such things as grids and charts, while in Microsoft Excel, you have objects such as worksheets and charts that provide this functionality. Using Visual Basic, Applications Edition with Microsoft Excel and Microsoft Project objects offers certain advantages. For example, these objects have greater functionality and there are many objects for which there are no comparable .VBX files, such as Pivot Tables.

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

   ARTICLE-ID: Q119095
   TITLE     : XL5: Utility That Allows Microsoft Excel to Use .VBX Files


Additional query words: compare comparison
Keywords : kbprg
Version : 1.00
Platform : WINDOWS


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: July 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.