Que, 2004. - 384 p.
Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications.
This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of the VBA language. It is very practical and offers the reader tested programs and projects that he or she can implement right away. This book reinforces the reader's learning by presenting useful, end-of-chapter pedagogical resources, including question-and-answer sessions and quizzes, as well as practical exercises that cement and extend the reader's knowledge. It explorers not only the object models of Word and Excel, but also other members of the Office 2003 suite, including PowerPoint, Access, and Outlook.
Getting Started with VBA
Recording Your First Macro
Writing Your Own Macros
Understanding Program Variables
Building VBA Expressions
Working with Objects
Controlling Your VBA Code
Putting VBA to Work
Programming Word
Programming Excel
Programming PowerPoint
Programming Access Databases
Programming Outlook Email
Getting the Most Out of VBA
Interacting with the User
Creating Custom VBA Dialog Boxes
Creating Custom Menus and Toolbars
Debugging VBA Procedures
Appendixes