VBA helps you put your computer in its place
Write programs that automate tasks and make Office 2007 work better for you
If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.
Discover how to
- Customize an application's interface
- Quick-launch a VBA program
- Store and modify information
- Use VBA with the Ribbon
- Understand object-oriented programming
- Avoid runtime errors
Welcome to your first look at Visual Basic for Applications (VBA)! You might think that VBA is a secret code used by advanced computer users to intimidate the rest of us. Nothing could be further from the truth. VBA is all about doing things your way. When you want an application to perform a task in a certain way, use VBA to extend it. VBA makes you the boss. After you discover the wonders of VBA, you can customize a number of applications to make them work the way you want them to work.
VBA is a tool that empowers you to perform tasks you never thought possible in a fraction of the time that it takes to perform the task by hand. For example, you can add new toolbars, create custom reports, and perform special kinds of data analysis. When you write a VBA program, you become the master of your environment — someone who gets the job done quickly.
Over 500 readers of the previous edition of this book sent me e-mail, many of whom told me about their current projects. After reviewing those messages for this edition of the book, I can truly say that VBA is an amazing tool because you’re doing amazing things with it. After seeing everything that people are doing with VBA, it’s easy to say that this is the tool for everyone!