Mastering VBA 6

Description

Visual Basic for Applications offers the ability to automate and customize the behavior of hundreds of VBA-compliant applications. This text gives a solid foundation in VBA programming, then moves on to tutorial-based instruction in specific techniques. Coverage includes: understanding what VBA is and what can be done with it; recording and editing macros in Microsoft Office applications; using the Visual Basic Editor to create and edit code; finding the objects, properties, and methods for procedures; using variables, constants, and arrays to store and manage information; creating loops to repeat actions in your code; using conditions to make decisions between different courses of action; navigating the object models of VBA-compliant applications; creating custom dialog boxes with user forms; building modular code for clarity and easy maintenance; testing and debugging code and user forms; and securing code with digital certificates and VBA 6 security features.

From the Back Cover

Learn Programming with VBA to Automate Your Work: Visual Basic for Applications is the most widespread application programming language around, offering you the ability to automate and customize the behavior of hundreds of VBA-compliant applications. Mastering VBA 6 begins by equipping you with a solid foundation in VBA programming, then moves on to clear, tutorial-based instruction in the specific techniques you need to know to get the performance you want. Coverage includes:

• Understanding what VBA is and what you can do with it
• Recording and editing macros in Microsoft Office applications
• Using the Visual Basic Editor to create and edit code
• Finding the objects, properties, and methods you need for your procedures
• Using variables, constants, and arrays to store and manage information
• Creating loops to repeat actions in your code
• Using conditions to make decisions between different courses of action
• Navigating the object models of VBA-compliant applications
• Creating custom dialog boxes with user forms
• Building modular code for clarity and easy maintenance
• Testing and debugging code and user forms
• Securing your code with digital certificates and VBA 6 security features

About the Author

Guy Hart-Davis is the author of Word 2000 Developer’s Handbook and Word 97 Macro & VBA Handbook, both published by Sybex. He uses VBA for fun and profit, and is an occasional contributor to the Visual Basic Programmer’s Journal.