Cargando…
Mastering VBA for Microsoft Office 2007 /
This text covers the basics of the language in clear, systematic tutorials, and includes intermediate and advanced content for experienced VB developers. Topics include recording macros and getting started with VBA, using loops and functions, creating effective code, and more.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley Pub.,
©2008.
|
| Colección: | Serious skills.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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 Windows""; ""Setting 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 ProceduresCreating 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 EnumerationsWorking 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
- 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""