Custom cover image
Mastering VBA for Microsoft Office 2013 / Richard Mansfield
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Publisher: Indianapolis, Ind : Sybex, 2013Edition: Online-AusgDescription: Online-Ressource (1 online resource (xxxv, 924 pages :)) : color illustrationsISBN:- 9781306451079
- 1306451078
- 9781118750223
- 005.36
- QA76.73.M53
Contents:
Summary: Cover -- Acknowledgments -- About the Author -- Introduction -- Part 1: Recording Macros and Getting Started with VBA -- Chapter 1: Recording and Running Macros in the Office Applications -- What Is VBA and What Can You Do with It? -- Understanding Macro Basics -- Recording a Macro -- Running a Macro -- Recording a Sample Word Macro -- Recording a Sample Excel Macro -- Specifying How to Trigger an Existing Macro -- Deleting a Macro -- The Bottom Line -- Chapter 2: Getting Started with the Visual Basic Editor -- Opening the Visual Basic Editor -- Using the Visual Basic Editor's Main Windows -- Setting Properties for a Project -- Customizing the Visual Basic Editor -- The Bottom Line -- Chapter 3: Editing Recorded Macros -- Testing a Macro in the Visual Basic Editor -- Editing the Word Macro -- Editing the Excel Macro -- Editing a PowerPoint Macro -- The Bottom Line -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Setting Up the Visual Basic Editor for Creating the Procedures -- Creating a Procedure for Word -- Creating a Procedure for Excel -- Creating a Procedure for PowerPoint -- Creating a Procedure for Access -- The Bottom Line -- Part 2: Learning How to Work with VBA -- Chapter 5: Understanding the Essentials of VBA Syntax -- Getting Ready -- Procedures -- Statements -- Keywords -- Expressions -- Operators -- Variables -- Constants -- Arguments -- Objects -- Collections -- Properties -- Methods -- Events -- The Bottom Line -- Chapter 6: Working with Variables, Constants, and Enumerations -- Working with Variables -- Working with Constants -- Working with Enumerations -- The Bottom Line -- 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.PPN: PPN: 807223085Package identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PAD | ZDB-30-PQE
No physical items for this record