Cart
Free Shipping in Australia
Proud to be B-Corp

VB and VBA in a Nutshell Paul Lomax

VB and VBA in a Nutshell By Paul Lomax

VB and VBA in a Nutshell by Paul Lomax


$25.99
Condition - Very Good
Only 3 left

Summary

In the tradition of "Java in a Nutshell", this book boils down the essentials of VB and VBA, and includes undocumented areas essential to everyday programming.

VB and VBA in a Nutshell Summary

VB and VBA in a Nutshell: The Languages by Paul Lomax

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.

About Paul Lomax

Paul Lomax is the author of Learning VBScript (published by O'Reilly & Associates) and technical director of Mentorweb (http://www.mentorweb.net/), a leading Web design and hosting company. Over the past two years Paul has created and maintained over 60 commercial Web sites for Mentorweb's clients. He is also the driving force behind ShopAssistant, a new NT/ASP based high-end shopping cart/Web commerce server (http://www.shopassistant.com/). He has been a programmer for over 12 years and has been a dedicated fan of Visual Basic since version 1. Paul has written systems for financial derivatives forecasting, satellite TV broadcasting, the life insurance industry, and he's written a major materials tracking system for the Oil and Gas industry. He is also responsible for the concept, design, and programming of the successful "Contact" series of national business databases. Paul has also created a Web resource dedicated to VBScript at http://www.vbscripts.com/. When not sitting in front of a keyboard, Paul can usually be found behind the wheel of a racing car competing in events around the UK. Paul and his family -- wife Deborah and children Russel and Victoria -- have recently returned to their home in England after several years spent living in the Arabian gulf.

Table of Contents

Preface Part I. The Basics Chapter 1. Introduction What Is VBA? A Brief History of VBA What Can You Do with VBA? Object Models: The Power of Programming with VBA Chapter 2. Program Structure Getting a VB Program to Run The Structure of a VB Program Ending Your VB Program Chapter 3. 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 Chapter 4. Class Modules Properties Enumerated Constants Class Module Events Implementing Custom Class Methods Creating ActiveX Components Using ActiveX Components in a Project Chapter 5. Automation 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 Chapter 6. Error Handling Building a Robust Application Error Handling in Procedures Error Handling in ActiveX Servers Reporting Errors Part II. Reference Chapter 7. The Language Reference Part III. Appendixes Appendix A. Language Elements by Category Appendix B. Language Constants Appendix C. Operators Appendix D. What's New in VB6? Index

Additional information

GOR001488898
9781565923584
1565923588
VB and VBA in a Nutshell: The Languages by Paul Lomax
Used - Very Good
Paperback
O'Reilly Media, Inc, USA
1998-10-01
652
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - VB and VBA in a Nutshell