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.
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.
What is VBA, and what can you do with it?; recording and running macros in the Microsoft Office applications; using the Visual Basic editor; editing recorded macros; the essentials of VBA syntax. working with variables and constants; using arrays; finding the objects you need; using and creating functions; creating procedures; using message boxes and input boxes; using loops to repeat actions; making decisions in your code; object models; creating simple custom dialog boxes; creating complex dialog boxes; building modular code; debugging your code; building well-behaved procedures; using VBA's security features.
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.
|
Ask a Question About this Product More... |
|
