Microsoft KB Archive/120362

= Differences Between VB 3.0 and Applications Edition =

PSS ID Number: 120362

Article Last Modified on 1/17/2001

-

The information in this article applies to:


 * Microsoft Visual Basic for Applications 1.0

-



This article was previously published under Q120362



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:

113334 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:

119095 XL5: Utility That Allows Microsoft Excel to Use .VBX Files

Additional query words: compare comparison

Keywords: KB120362

Technology: kbVBA100 kbVBASearch kbZNotKeyword3 kbZNotKeyword6

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.