VBA For Dummies^®, 5th Edition

by John Paul Mueller

• ISBN13: 9780470126998
• ISBN10: 047012699X
• Format: eBook
• Copyright: 2007-04-01
• Publisher: For Dummies

Summary

VBA helps you put your computer in its place Write programs that automate tasks and make Office 2007 work better for you If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications. Discover how to Customize an application's interface Quick-launch a VBA program Store and modify information Use VBA with the Ribbon Understand object-oriented programming Avoid runtime errors

Table of Contents

Introduction

An Overview of VBA

Getting to Know VBA

Your First VBA Program

Learning the Ropes

Writing Structured VBA Programs

Storing and Modifying Information

Creating Structured Programs

Trapping Errors and Squashing Bugs

Interacting with the User

Expanding Your VBA Horizons

Object -Oriented Programming

Working with Arrays and Collections

Working with Disk Files

VBA Programming with XML

Programming for Applications

VBA Programming in Office

VBA Programming in Word

VBA Programming in Excel

VBA Programming in Access

Applications that Work Together

The Part of Tens

Ten Kinds of VBA Resources

Ten Ways to Update Your Old VBA Code Quickly

On the Web

Bonus

VBA Programming in Front Page

Bonus

VBA Programming in Visio

Bonus

Ten Really Cool Things You Can Do with VBA

Index

Table of Contents provided by Publisher. All Rights Reserved.