Absolute Beginner's Guide To Vba

  Absolute Beginner's Guide to VBA shows you how to take full advantage of the Microsoft Office Suite by automating routine Office tasks. No matter which Office application you're using, there are some tasks you perform dozens of times, such as typing and formatting a section of text, running a series of menu commands, or editing a document in a particular way. This book shows you how to accomplish the same results with the click of a button. Even if you've never programmed before, the simple step-by-step approach of Absolute Beginner's Guide to VBA will have you up to speed with VBA in no time! With Absolute Beginner's Guide to VBA you'll be creating macros and automating Microsoft Office in no time! Here's a small sample of what you'll find inside: Practical, real-world examples for anyone who uses Office applications - not just hardcore power users. How to automate or streamline all of your repetitive Word, Excel, and Outlook chores. How to create custom menus, toolbars, and dialog boxes to make Office look and work the way you want it to - no programming experience required! Easy-to-understand instructions that make learning VBA fast and fun.   Table of Contents Introduction. I. GETTING STARTED WITH VBA. 1. Recording Your First Macro.   2. Writing Your Own Macros.   3. Understanding Program Variables.   4. Building VBA Expressions.   5. Working with Objects.   6. Controlling Your VBA Code.   II. PUTTING VBA TO WORK. 7. Programming Word.   8. Programming Excel.   9. Programming PowerPoint.   10. Programming Access Databases.   11. Programming Outlook Email.   III. GETTING THE MOST OUT OF VBA. 12. Interacting with the User.   13. Creating Custom VBA Dialog Boxes.   14. Creating Custom Menus and Toolbars.   15. Debugging VBA Procedures.   IV. APPENDIXES. Appendix A. VBA Statements.   Appendix B. VBA Functions.