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.
Inhaltsverzeichnis
Preface;
Why Another VB Book?;
What's Wrong with the Online Help?;
Who Should Read This Book?;
How This Book Should Be Used;
How This Book Is Structured;
Conventions Used in This Book;
How to Contact Us;
Acknowledgments;
Part II: The Basics;
Chapter 1: Introduction;
1.1 What Is VBA?;
1.2 A Brief History of VBA;
1.3 What Can You Do with VBA?;
1.4 Object Models: The Power of Programming with VBA;
Chapter 2: Program Structure;
2.1 Getting a VB Program to Run;
2.2 The Structure of a VB Program;
2.3 Ending Your VB Program;
Chapter 3: VBA Variables and Data Types;
3.1 Visual Basic Data Types;
3.2 Type Conversion;
3.3 The Variant;
3.4 Declaring Variables and Constants;
3.5 Array Variables;
3.6 User -Defined Types;
3.7 Variable Scope and Lifetime;
3.8 Object Variables and Binding;
3.9 Passing Parameters;
3.10 Intrinsic Constants;
Chapter 4: Class Modules;
4.1 Properties;
4.2 Enumerated Constants;
4.3 Class Module Events;
4.4 Implementing Custom Class Methods;
4.5 Creating ActiveX Components;
4.6 Using ActiveX Components in a Project;
Chapter 5: Automation;
5.1 Creating Object Model References;
5.2 Reading the Object Model;
5.3 Working with the Object Model;
5.4 Collection Objects;
5.5 Trapping an Automation Server's Events;
5.6 Automation Examples;
5.7 Automation Performance Tips;
Chapter 6: Error Handling;
6.1 Building a Robust Application;
6.2 Error Handling in Procedures;
6.3 Error Handling in ActiveX Servers;
6.4 Reporting Errors;
Part III: Reference;
Chapter 7: The Language Reference;
Chapter 8: The Language Reference, Part 1: #Const Directive-Drives Collection Object (VB6);
Chapter 9: The Language Reference, Part 2: End... Statement-FV Function;
Chapter 10: The Language Reference, Part 3: Get Statement-PV Function;
Chapter 11: The Language Reference, Part 4: QBColor Function-Year Function;
Part IV: Appendixes;
Appendix A: Language Elements by Category;
A.1 Collection Object;
A.2 Conditional Compilation;
A.3 Data Type Conversion Functions;
A.4 Data Bindings Objects (VB6 only);
A.5 Date and Time Functions;
A.6 Dictionary Object (VB6 Only);
A.7 Err Object;
A.8 FileSystem Objects (VB6 only);
A.9 File and Folder Handling;
A.10 Financial Functions;
A.11 Formatting Functions;
A.12 Information Functions;
A.13 Interaction Functions;
A.14 Math Functions;
A.15 Programming and ActiveX Programming;
A.16 Printer ObjectNot available in hosted versions of VBA;
A.17 Program Structure and Flow;
A.18 Registry Functions;
A.19 String Manipulation;
A.20 Variable Declaration;
Appendix B: Language Constants;
B.1 Application Window Style (VbAppWinStyle);
B.2 Calendar (VBCalendar);
B.3 Call Type (VB6 only);
B.4 Compare Method (VbCompareMethod);
B.5 Data Binding Update Mode (VB6 Only);
B.6 Date Time Format Styles (VB6 Only);
B.7 Day of Week (VbDayOfWeek);
B.8 Drive Type (VB6 only);
B.9 File Attributes (VbFileAttribute);
B.10 File System Objects File Attributes (VB6 Only);
B.11 First Week of Year (VbFirstWeekOfYear);
B.12 IME Status (VbIMEStatus);
B.13 Language Constants;
B.14 Log Event Type Style (LogEventTypeConstants);
B.15 Log Mode Constants (VB6 only);
B.16 Message Box Result (VbMsgBoxResult);
B.17 Message Box Style (VbMsgBoxStyle);
B.18 Special Folder Types (VB6 only);
B.19 String Conversion (VbStrConv);
B.20 TextStream IOMode (VB6 only);
B.21 Tristate Constants (VB6 Only);
B.22 Variant Type (VbVarType);
Appendix C: Operators;
C.1 Arithmetic Operators;
C.2 String Operator;
C.3 Comparison Operators;
C.4 Logical and Bitwise Operators;
C.5 Operator Precedence;
Appendix D: What's New in VB6?;
D.1 Create DataSource and Data Consumer Classes;
D.2 Functions Can Return Arrays;
D.3 Dynamic Arrays Can Be Assigned;
D.4 Remote User-Defined Types;
D.5 New Functions;
D.6 Enhanced CreateObject Function;
D.7 New Object Models;
Colophon;
