Mastering VBA for Microsoft Office 2013
- 18h 39m
- Richard Mansfield
- Sybex
- 2013
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.
About the Author
Richard Mansfield is the author or coauthor of 45 books, including Visual Basic 6 Database Programming For Dummies, Office 2003 Application Development All-in-One Desk Reference For Dummies, How to Do Everything with Second Life, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.
In this Book
-
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
-
Securing Your Code with 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
-
Manipulating the Data in an Access Database via VBA
-
Accessing One Application from Another Application
-
Programming the Office 2013 Ribbon
