Mastering VBA for Microsoft Office 2007
Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of re...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Indianapolis, Ind. :
Wiley Pub
c2008.
|
| Edition: | 2nd ed |
| Series: | Serious skills.
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009849119906719 |
Table of Contents:
- Mastering VBA for Microsoft Office 2007; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; Part 1: Recording Macros and Getting Started with VBA; Chapter 1: Recording and Running Macros in the Microsoft 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; Assigning a Way of Running the 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 WindowsSetting Properties for a Project; Customizing the Visual Basic Editor; Closing the Visual Basic Editor and Returning to the Host Application; 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 PowerPointCreating 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 ArrayMultidimensional Arrays; Declaring a Dynamic Array; Redimensioning an Array; Returning Information from an Array; Erasing an Array; Finding Out Whether a Variable Is an Array; Finding the Bounds of an Array; Sorting an Array; Searching Through an Array; The Bottom Line; Chapter 8: Finding the Objects, Methods, and Properties You Need; What Is an Object?; Working with Collections; Finding the Objects You Need; Using Object Variables to Represent Objects; The Bottom Line; Part 3: Making Decisions and Using Loops and Functions; Chapter 9: Using Functions
- What Is a Function?Using Functions; Using Functions to Convert Data from One Type to Another; Using Functions to Manipulate Strings; Using VBA's Mathematical Functions; Using VBA's Date and Time Functions; Using File-Management Functions; The Bottom Line; Chapter 10: Creating Your Own Functions; Components of a Function; Creating a Function; Examples of Functions for Any VBA-Enabled Application; Creating a Function for Word; Creating a Function for Excel; Creating a Function for PowerPoint; Creating a Function for Access; The Bottom Line; Chapter 11: Making Decisions in Your Code
- How Do You Compare Things in VBA?
