Mastering VBA for Microsoft Office 2007 / Richard Mansfield.

Format:

Book

Author/Creator:

Mansfield, Richard, 1945-

Series:

Serious skills.

Sybex serious skills

Language:

English

Subjects (All):

Business--Computer programs.

Business.

Microsoft Office.

Microsoft Visual Basic for applications.

Physical Description:

1 online resource (890 p.)

Edition:

2nd ed.

Place of Publication:

Indianapolis, Ind. : Wiley Pub., c2008.

Language Note:

English

Summary:

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 recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

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?

Notes:

Description based on publisher supplied metadata and other sources.

Includes index.

ISBN:

1-281-38212-4

9786611382124

0-470-37845-X

OCLC:

297572645