Product Description

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

Product Details

• Amazon Sales Rank: #994042 in Books
• Published on: 2000-02-03
• Original language: English
• Binding: Paperback
• 704 pages

Book Info
Covers what VBA is and what you can do with it using the Visual Basic Editor to create and edit code, creating loops to repeat actions in your code. Softcover. CD-ROM included.

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.