Book description
Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft's Visual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.
Table of contents
- Cover
- Contents
- Title
- Copyright
- Dedication
- Acknowledgments
- About the Author
- Introduction
- Part 1: Recording Macros and Getting Started with VBA
-
Part 2: Learning How to Work With VBA
- Chapter 5: Understanding the Essentials of VBA Syntax
- Chapter 6: Working with Variables, Constants, and Enumerations
-
Chapter 7: Using Array Variables
- What is an Array?
- Declaring an Array
- Storing Values in an Array
- Multidimensional Arrays
- Declaring a Dynamic Array
- Redimensioning an Array
- Returning Information from an Array
- Erasing an Array
- Finding Out Whether a Variable is an Array
- Finding the Bounds of an Array
- Sorting an Array
- Searching Through an Array
- The Bottom Line
- Chapter 8: Finding the Objects, Methods, and Properties You Need
- Part 3: Making Decisions and Using Loops and Functions
- Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes
- Part 5: Creating Effective Code
-
Part 6: Programming the Office Applications
- Chapter 20: Understanding the Word Object Model and Key Objects
- Chapter 21: Working with Widely Used Objects in Word
- Chapter 22: Understanding the Excel Object Model and Key Objects
- Chapter 23: Working with Widely Used Objects in Excel
- Chapter 24: Understanding the PowerPoint Object Model and Key Objects
- Chapter 25: Working with Shapes and Running Slide Shows
- Chapter 26: Understanding the Outlook Object Model and Key Objects
- Chapter 27: Working with Events in Outlook
- Chapter 28: Understanding the Access Object Model and Key Objects
- Chapter 29: Manipulating the Data in an Access Database via VBA
- Chapter 30: Accessing One Application from Another Application
-
Chapter 31: Programming the Office 2007 Ribbon
- Hiding the Editing Group on the Word Ribbon
- Working with Excel and PowerPoint
- Undoing Ribbon Modifications
- Selecting the Scope of Your Ribbon Customization
- Adding a New Group
- Adding Callbacks
- Adding Attributes
- Using Menus and Lists
- Toggling with a Toggle Button Control
- Modifying the Ribbon in Access
- Adding a Callback in Access
- What to Look For if Things Go Wrong
- Where to Go from Here
- The Bottom Line
- Appendix: The Bottom Line Solutions
- Glossary
- Index
Product information
- Title: Mastering VBA for Microsoft Office 2007, 2nd Edition
- Author(s):
- Release date: April 2008
- Publisher(s): Sybex
- ISBN: 9780470279595
You might also like
book
Mastering VBA for Microsoft® Office 2010
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) …
book
Business Solutions VBA for the 2007 Microsoft Office System
“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able …
book
Access™ 2007 VBA Bible: For Data-Centric Microsoft® Office Applications
Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft …
book
Beginning Access™ 2007 VBA
This book provides you with the tools and techniques you'll need in order to build more …