Mastering VBA for Microsoft Office 365, 2019 Edition
- 17h 53m
- Richard Mansfield
- Sybex
- 2019
The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint.
Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have been modified during the three years since the last version of this book. Various elements within VBA have been deprecated or replaced, and the surface UI changed as well. The updated 2019 edition covers topics such as:
- 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
Written for all levels of Microsoft Office 365 users, Mastering VBA Microsoft Office 365: 2019 Edition explains how to customize and automate the Office suite of applications.
About the Author
Richard Mansfield is a widely recognized expert on computer programming. He's the author of more than 44 computer books that have sold over half a million copies worldwide. They include Visual Basic .NET Power Toolkit, Visual Basic .NET Database Programming For Dummies, and Programming: A Beginner's Guide, as well as several previous editions of Mastering VBA for Microsoft Office. Richard is also the former editor of Compute! magazine.
In this Book
-
Introduction
-
Recording and Running Macros in the Office Applications
-
Getting Started with the Visual Basic Editor
-
Editing Recorded Macros
-
Creating Code from Scratch in the Visual Basic Editor
-
Understanding the Essentials of VBA Syntax
-
Working with Variables, Constants, and Enumerations
-
Using Array Variables
-
Finding the Objects, Methods, and Properties You Need
-
Using Built-in Functions
-
Creating Your Own Functions
-
Making Decisions in Your Code
-
Using Loops to Repeat Actions
-
Getting User Input with Message Boxes and Input Boxes
-
Creating Simple Custom Dialog Boxes
-
Creating Complex Forms
-
Building Modular Code and Using Classes
-
Debugging Your Code and Handling Errors
-
Building Well-Behaved Code
-
Exploring VBA's Security Features
-
Understanding the Word Object Model and Key Objects
-
Working with Widely Used Objects in Word
-
Understanding the Excel Object Model and Key Objects
-
Working with Widely Used Objects in Excel
-
Understanding the PowerPoint Object Model and Key Objects
-
Working with Shapes and Running Slide Shows
-
Understanding the Outlook Object Model and Key Objects
-
Working with Events in Outlook
-
Understanding the Access Object Model and Key Objects
-
Accessing One Application from Another Application
