tailieunhanh - VBA for the 2007 Microsoft Office System

Microsoft Office 2007 is the latest-and-greatest version of a long line of versions, starting (not surprisingly. Not that this is the 2,007th version. Somewhere along the way Microsoft switched from using sequential numbers for versions to using Pirsig, in Zen and the Art of Motorcycle Maintenance, wrote that “a person who sees Quality and feels it as he works, is a person who cares.” If this book is a quality product (and I immodestly think that it is), it’s because the people at Que editorial cared enough to make it so. So a round of hearty thanks is in order for all the. | Contents at a Glance I Getting Started with VBA 1 Creating and Running Recorded Macros . . . . . . . . . . . . . . . . . . . . . . . . 3 2 Writing Your Own Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 3 Understanding Program Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 4 Building VBA Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 usinesssolutions 5 Working with Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .71 ? 6 Controlling Your VBA Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 II Putting VBA to Work 7 Programming Word . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 8 Programming Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 9 Programming PowerPoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 10 Programming Access Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189 11 Programming Outlook Email . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213 VBA III Getting the Most Out of VBA 12 Creating Custom VBA Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . 237 for the 13 Customizing the Office 2007 Ribbon . . . . . . . . . . . . . . . . . . . . . . . . 263 ® 14 VBA Tips and Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 15 Trapping Program Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323 2007 Microsoft 16 Debugging VBA Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337 IV Appendixes Office System A VBA Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 B VBA Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 361 Index . . . . . . . . . . . . . . . . . . . .