9780470634004

Office 2010 brings profound, new ways to extend its applications with VBA programming. This book covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers. It addresses not just one Office application, but the whole Office suite. Further, all of the content is anchored with solid, real-world projects in Word, Excel, Outlook, PowerPoint, and Access. Topics include 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.

TERM	PRICE	DUE
SHORT TERM	$42.88	Jun 07

Richard Mansfield is the author or coauthor of more than 40 computer books, includingVisual Basic .NET Power Toolkit, Office 2003 Application Development All-in-One Desk Reference For Dummies, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.

Recording Macros and Getting Started with VBA
Recording and Running Macros in the Microsoft Office Applications
Getting Started with the Visual Basic Editor
Editing Recorded Macros
Creating Code from Scratch in the Visual Basic Editor
Learning How to Work with VBA
Understanding the Essentials of VBA Syntax
Working with Variables, Constants, and Enumerations
Using Array Variables
Finding the Objects, Methods, and Properties You Need
Making Decisions and Using Loops and Functions
Using Built-In Functions
Creating Your Own Functions
Making Decisions in Your Code
Using Loops to Repeat Actions
Using Message Boxes, Input Boxes, and Dialog Boxes
Getting User Input with Message Boxes and Input Boxes
Creating Simple Custom Dialog Boxes
Creating Complex Dialog Boxes
Creating Effective Code
Building Modular Code and Using Classes
Debugging Your Code and Handling Errors
Building Well-Behaved Code
Securing Your Code with VBA's Security Features
Programming the Office Applications
Understanding the Word Object Model and Key Objects
Working with Widely Used Objects in Word
Understanding the Excel Object Model and Key Objects
Working with Widely Used Objects in Excel
Understanding the PowerPoint Object Model and Key Objects
Working with Shapes and Running Slide Shows
Understanding the Outlook Object Model and Key Objects
Working with Events in Outlook
Understanding the Access Object Model and Key Objects
Manipulating the Data in an Access Database via VBA
Accessing One Application from Another Application
Programming the Office 2010 Ribbon
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Mastering Vba for Office 2010

Mastering Vba for Office 2010

0470634006

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review