book

Mastering VBA for Microsoft Office 2013

by Richard Mansfield

August 2013

Beginner

960 pages

28h 49m

English

Sybex

Read now

Unlock full access

Where to Get This Book's Example CodeIf You Have QuestionsWhat Can I Do with VBA?What's in This Book?How Should I Use This Book?Is This Book Suitable for Me?Conventions Used in This BookThe Mastering SeriesFor More Information

What Is VBA and What Can You Do with It?Understanding Macro BasicsRecording a MacroRunning a MacroRecording a Sample Word MacroRecording a Sample Excel MacroSpecifying How to Trigger an Existing MacroDeleting a MacroThe Bottom Line
Opening the Visual Basic EditorUsing the Visual Basic Editor's Main WindowsSetting Properties for a ProjectCustomizing the Visual Basic EditorThe Bottom Line
Testing a Macro in the Visual Basic EditorEditing the Word MacroEditing the Excel MacroEditing a PowerPoint MacroThe Bottom Line
Setting Up the Visual Basic Editor for Creating the ProceduresCreating a Procedure for WordCreating a Procedure for ExcelCreating a Procedure for PowerPointCreating a Procedure for AccessThe Bottom Line
Getting ReadyProceduresStatementsKeywordsExpressionsOperatorsVariablesConstantsArgumentsObjectsCollectionsPropertiesMethodsEventsThe Bottom Line
Working with VariablesWorking with ConstantsWorking with EnumerationsThe Bottom Line
What Is an Array?Declaring an ArrayStoring Values in an ArrayMultidimensional ArraysDeclaring a Dynamic ArrayRedimensioning an ArrayReturning Information from an ArrayErasing an ArrayFinding Out Whether a Variable Is an ArrayFinding the Bounds of an ArraySorting an ArraySearching through an ArrayThe Bottom Line
What Is an Object?Working with CollectionsFinding the Objects You NeedUsing Object Variables to Represent ObjectsTeam Programming and OOPThe Bottom Line
What Is a Function?Using FunctionsUsing Functions to Convert DataUsing Functions to Manipulate StringsUsing VBA's Mathematical FunctionsUsing VBA's Date and Time FunctionsUsing File-Management FunctionsThe Bottom Line
Components of a FunctionCreating a FunctionExamples of Functions for Any VBA-Enabled Office ApplicationCreating a Function for WordCreating a Function for ExcelCreating a Function for PowerPointCreating a Function for AccessThe Bottom Line
How Do You Compare Things in VBA?Testing Multiple Conditions by Using Logical OperatorsSelect Case BlocksThe Bottom Line
When Should You Use a Loop?Understanding the Basics of LoopsUsing For…loops for Fixed RepetitionsUsing Do… Loops for Variable Numbers of RepetitionsWhile… Wend LoopsNesting LoopsAvoiding Infinite LoopsThe Bottom Line
Opening a Procedure to Work OnDisplaying Status-Bar Messages in Word and ExcelMessage BoxesInput BoxesForms: When Message Boxes and Input Boxes Won't SufficeThe Bottom Line
When Should You Use a Custom Dialog Box?Creating a Custom Dialog BoxLinking a Form to a ProcedureRetrieving the User's Choices from a Dialog BoxExamples of Connecting Forms to ProceduresUsing an Application's Built-in Dialog Boxes from VBAThe Bottom Line
Creating and Working with Complex Dialog BoxesUsing Events to Control FormsThe Bottom Line
Creating Modular CodeCreating and Using ClassesThe Bottom Line
Principles of DebuggingThe Different Types of ErrorsVBA's Debugging ToolsDealing with Infinite LoopsDealing with Runtime ErrorsSuppressing AlertsHandling User Interrupts in Word, Excel, and ProjectDocumenting Your CodeThe Bottom Line
What Is a Well-Behaved Procedure?Retaining or Restoring the User EnvironmentLeaving the User in the Best Position to Continue WorkingKeeping the User Informed during the ProcedureMaking Sure a Procedure Is Running under Suitable ConditionsCleaning Up after a ProcedureThe Bottom Line
Understanding How VBA Implements SecuritySigning Your Macro Projects with Digital SignaturesChoosing a Suitable Level of SecurityLocking Your CodeThe Bottom Line
Examining the Word Object ModelWorking with the Documents Collection and the Document ObjectWorking with the Selection ObjectCreating and Using RangesManipulating OptionsThe Bottom Line
Using Find and Replace via VBAWorking with Headers, Footers, and Page NumbersWorking with Sections, Page Setup, Windows, and ViewsWorking with TablesThe Bottom Line
Getting an Overview of the Excel Object ModelUnderstanding Excel's Creatable ObjectsManaging WorkbooksWorking with WorksheetsWorking with the Active Cell or SelectionWorking with RangesSetting OptionsThe Bottom Line
Working with ChartsWorking with WindowsWorking with Find and ReplaceAdding ShapesThe Bottom Line
Getting an Overview of the PowerPoint Object ModelUnderstanding PowerPoint's Creatable ObjectsWorking with PresentationsWorking with Windows and ViewsWorking with SlidesWorking with MastersThe Bottom Line
Working with ShapesWorking with Headers and FootersSetting Up and Running a Slide ShowThe Bottom Line
Getting an Overview of the Outlook Object ModelWorking with the Application ObjectUnderstanding General Methods for Working with Outlook ObjectsWorking with MessagesWorking with Calendar ItemsWorking with Tasks and Task RequestsSearching for ItemsThe Bottom Line
Working with Application-Level EventsWorking with Item-Level EventsUnderstanding Quick StepsThe Bottom Line
Getting Started with VBA in AccessGetting an Overview of the Access Object ModelUnderstanding Creatable Objects in AccessOpening and Closing DatabasesWorking with the Screen ObjectUsing the DoCmd Object to Run Access CommandsThe Bottom Line
Understanding How to ProceedPreparing to Manage the Data in a DatabaseOpening a RecordsetAccessing a Particular Record in a RecordsetSearching for a RecordReturning the Fields in a RecordEditing a RecordInserting and Deleting RecordsClosing a RecordsetSaving a Recordset to the CloudThe Bottom Line
Understanding the Tools Used to Communicate between ApplicationsUsing Automation to Transfer InformationUsing the Shell Function to Run an ApplicationUsing Data Objects to Store and Retrieve InformationCommunicating via DDECommunicating via SendKeysGoing beyond VBAThe Bottom Line
What Is XML?Hiding the Editing Group on the Word RibbonWorking with Excel and PowerPointUndoing Ribbon ModificationsSelecting the Scope of Your Ribbon CustomizationAdding a New GroupAdding CallbacksAdding AttributesUsing Menus and ListsToggling with a Toggle-Button ControlModifying the Ribbon in AccessAdding a Callback in AccessWhat to Look For If Things Go WrongWhere to Go from HereThe Bottom Line
Chapter 1: Recording and Running Macros in the Office ApplicationsChapter 2: Getting Started with the Visual Basic EditorChapter 3: Editing Recorded MacrosChapter 4: Creating Code from Scratch in the Visual Basic EditorChapter 5: Understanding the Essentials of VBA SyntaxChapter 6: Working with Variables, Constants, and EnumerationsChapter 7: Using Array VariablesChapter 8: Finding the Objects, Methods, and Properties You NeedChapter 9: Using Built-in FunctionsChapter 10: Creating Your Own FunctionsChapter 11: Making Decisions in Your CodeChapter 12: Using Loops to Repeat ActionsChapter 13: Getting User Input with Message Boxes and Input BoxesChapter 14: Creating Simple Custom Dialog BoxesChapter 15: Creating Complex FormsChapter 16: Building Modular Code and Using ClassesChapter 17: Debugging Your Code and Handling ErrorsChapter 18: Building Well-Behaved CodeChapter 19: Securing Your Code with VBA's Security FeaturesChapter 20: Understanding the Word Object Model and Key ObjectsChapter 21: Working with Widely Used Objects in WordChapter 22: Understanding the Excel Object Model and Key ObjectsChapter 23: Working with Widely Used Objects in ExcelChapter 24: Understanding the PowerPoint Object Model and Key ObjectsChapter 25: Working with Shapes and Running Slide ShowsChapter 26: Understanding the Outlook Object Model and Key ObjectsChapter 27: Working with Events in OutlookChapter 28: Understanding the Access Object Model and Key ObjectsChapter 29: Manipulating the Data in an Access Database via VBAChapter 30: Accessing One Application from Another ApplicationChapter 31: Programming the Office 2013 Ribbon

Overview

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Mastering VBA for Microsoft Office 2007, 2nd Edition

Publisher Resources

ISBN: 9781118695128Purchase book

Mastering VBA for Microsoft Office 2013

by Richard Mansfield

Overview

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Mastering VBA for Microsoft Office 2007, 2nd Edition

Mastering VBA for Microsoft Office 2016

Mastering VBA for Microsoft® Office 2010

Excel® 2013 VBA and Macros

Publisher Resources

Overview

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Mastering VBA for Microsoft Office 2007, 2nd Edition

Mastering VBA for Microsoft Office 2016

Mastering VBA for Microsoft® Office 2010

Excel® 2013 VBA and Macros

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.