Book description
Enhance productivity in any Office application with zero programming experienceMastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint.
Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight.
- Expand Office 2016 functionality with macros
- Learn how to work with VBA and the entire Office suite
- Create effective code, even with no programing experience
- Understand ActiveX, XML-based files, the developer tab, and more
VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.
Table of contents
- Title Page
- 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
- Determining Whether a Variable Is an Array
- Finding the Bounds of an Array
- Sorting an Array
- Searching an Array
- The Bottom Line
- Chapter 8: Finding the Objects, Methods, and Properties You Need
-
Part 3: Making Decisions and Using Loops and Functions
-
Chapter 9: Using Built-In Functions
- What Is a Function?
- Using Functions
- Using Functions to Convert Data
- Using the Asc Function to Return a Character Code
- Using the Val Function to Extract a Number from the Start of a String
- Using the Format Function to Format an Expression
- Using the Chr Function and Constants to Enter Special Characters in a String
- Using Functions to Manipulate Strings
- Using the Left, Right, and Mid Functions to Return Part of a String
- Using InStr and InStrRev to Find a String Within Another String
- Using LTrim, RTrim, and Trim to Remove Spaces from a String
- Using Len to Check the Length of a String
- Using StrConv, LCase, and UCase to Change the Case of a String
- Using the StrComp Function to Compare Apples to Apples
- Using VBA's Mathematical Functions[[Page_232]]
- Using VBA's Date and[[Page_233]] Time Functions
- Using the DatePart Function to Parse Dates
- Calculating Time Intervals Using the DateDiff Function
- Using the DateAdd Function to Add or Subtract Time from a Date
- Using File-Management Functions
- Checking Whether a File Exists Using the Dir Function
- The Bottom Line
- Chapter 10: Creating Your Own Functions
- Chapter 11: Making Decisions in Your Code
- Chapter 12: Using Loops to Repeat Actions
-
Chapter 9: Using Built-In 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
- Examining the Word Object Model
- Working with the Documents Collection and the Document Object
- Saving a Document
- Opening a Document
- Closing a Document
- Printing a Document
- Working with the ActiveDocument Object
- Working with the Selection Object
- Creating and Using Ranges
- Manipulating Options
- The Bottom Line
- 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 2016 Ribbon
- What Is XML?
- Hiding the Clipboard 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
-
Chapter 20: Understanding the Word Object Model and Key Objects
-
Appendix: The Bottom Line
- Chapter 1: Recording and Running Macros in the Office Applications
- Chapter 2: Getting Started with the Visual Basic Editor[[Page_878]]
- 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: Exploring 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 2016 Ribbon
- End User License Agreement
Product information
- Title: Mastering VBA for Microsoft Office 2016
- Author(s):
- Release date: February 2016
- Publisher(s): Sybex
- ISBN: 9781119225386
You might also like
book
Mastering VBA for Microsoft Office 2013
A unique, comprehensive guide to creating custom apps with VBA Automating computing tasks to increase productivity …
book
Microsoft® Access® 2010 VBA Programming Inside Out
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic …
book
Excel® 2013 VBA and Macros
SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel® 2013 VBA and Macros …
book
Excel 2016 VBA and Macros
This is the Rough Cut version of the printed book. SAVE TIME AND SUPERCHARGE EXCEL 2016 …