Book description
A unique, comprehensive guide to creating custom apps with VBA
Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access.
Covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers
Explores recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security
Anchors the content with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access
Covering VBA for the entire suite of Office 2013 applications, Mastering VBA for Microsoft Office 2013 is mandatory reading.
Table of contents
- Cover Page
- Title Page
- Copyright
- Wiley
- Dedication
- Acknowledgments
- About the Author
- Contents at a Glance
- Contents
- 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
- Understanding How to Proceed
- Preparing to Manage the Data in a Database
- Opening a Recordset
- Accessing a Particular Record in a Recordset
- Searching for a Record
- Returning the Fields in a Record
- Editing a Record
- Inserting and Deleting Records
- Closing a Recordset
- Saving a Recordset to the Cloud
- The Bottom Line
- Chapter 30: Accessing One Application from Another Application
-
Chapter 31: Programming the Office 2013 Ribbon
- What Is XML?
- 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
- Chapter 1: Recording and Running Macros in the Office Applications
- Chapter 2: Getting Started with the Visual Basic Editor
- Chapter 3: Editing Recorded Macros
- Chapter 4: Creating Code from Scratch in the Visual Basic Editor
- Chapter 5: Understanding the Essentials of VBA Syntax
- Chapter 6: Working with Variables, Constants, and Enumerations
- Chapter 7: Using Array Variables
- Chapter 8: Finding the Objects, Methods, and Properties You Need
- Chapter 9: Using Built-in Functions
- Chapter 10: Creating Your Own Functions
- Chapter 11: Making Decisions in Your Code
- Chapter 12: Using Loops to Repeat Actions
- Chapter 13: Getting User Input with Message Boxes and Input Boxes
- Chapter 14: Creating Simple Custom Dialog Boxes
- Chapter 15: Creating Complex Forms
- Chapter 16: Building Modular Code and Using Classes
- Chapter 17: Debugging Your Code and Handling Errors
- Chapter 18: Building Well-Behaved Code
- Chapter 19: Securing Your Code with VBA's Security Features
- 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 2013 Ribbon
- Index
Product information
- Title: Mastering VBA for Microsoft Office 2013
- Author(s):
- Release date: August 2013
- Publisher(s): Sybex
- ISBN: 9781118695128
You might also like
book
Mastering VBA for Microsoft Office 2007, 2nd Edition
Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and …
book
Mastering VBA for Microsoft® Office 2010
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) …
book
Mastering VBA for Microsoft Office 2016
Enhance productivity in any Office application with zero programming experience Mastering VBA for Microsoft Office 2016 …
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 …