+612 9045 4394
VB & VBA in a Nutshell - The Languages : The Languages - Paul Lomax

VB & VBA in a Nutshell - The Languages

The Languages


Published: 1st October 1998
Ships: 15 business days
15 business days
RRP $64.00

The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB & VBA in a Nutshell: The Language, it finally is available.

The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information:

  • Its syntax, using standard code conventions
  • Differences in the operation of the keyword in a macro environment (e.g., in Office) and in Visual Basic, if there are any
  • A list of arguments accepted by the function or procedure, if any
  • A description of the data type returned by a function
  • The finer points of a keyword's usage that are often omitted from or blurred over by the documentation
  • Tips and gotchas that include undocumented behaviors and practical applications for particular language elements -- a section particularly invaluable for diagnosing or avoiding potential programming problems
  • A brief, nonobvious example that illustrates the use of the keyword

Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including:

  • Basic VBA programming concepts, such as its data types and its support for variables, constants, and arrays
  • Error handling in VBA applications
  • Object programming with VBA
  • Using VBA with particular applications. Excel and Project are utilized to show how to work with an application's integrated development environment and to take advantage of its object model Regardless of how much experience you have programming with VBA, this is the book you'll pick up time and time again both as your standard reference guide and as a tool for troubleshooting and identifying programming problems.
VB & VBA in a Nutshell: The Language is the definitive reference for Visual Basic and VBA developers.

The Basics
What Is VBA?
A Brief History of VBA
What Can You Do with VBA?
Object Models: The Power of Programming with VBA
Program Structure
Getting a VB Program to Run
The Structure of a VB Program
Ending Your VB Program
VBA Variables and Data Types
Visual Basic Data Types
Type Conversion
The Variant
Declaring Variables and Constants
Array Variables
User-Defined Types
Variable Scope and Lifetime
Object Variables and Binding
Passing Parameters
Intrinsic Constants
Class Modules
Enumerated Constants
Class Module Events
Implementing Custom Class Methods
Creating ActiveX Components
Using ActiveX Components in a Project
Creating Object Model References
Reading the Object Model
Working with the Object Model
Collection Objects
Trapping an Automation Server's Events
Automation Examples
Automation Performance Tips
Error Handling
Building a Robust Application
Error Handling in Procedures
Error Handling in ActiveX Servers
Reporting Errors
The Language Reference
Language Elements by Category
Language Constants
What's New in VB6?
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781565923584
ISBN-10: 1565923588
Series: In a Nutshell (O'Reilly)
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 552
Published: 1st October 1998
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 22.7 x 16.5  x 3.39
Weight (kg): 0.86