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
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 22.8 cm
Breite: 19 cm
Gewicht
ISBN-13
978-0-7821-2636-5 (9780782126365)
Schweitzer Klassifikation
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.
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.
