Cover image for VBA for dummies.
VBA for dummies.
Mueller, John, 1958-
Personal Author:
Fourth edition / John Paul Mueller.
Publication Information:
Hoboken, NJ : Wiley Publishing, Inc., [2003]

Physical Description:
xviii, 390 pages : illustrations ; 24 cm.
General Note:
Includes index.

Previous ed.: published as by Steve Cummings. 2001.
Title Subject:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.76.D47 C86 2003 Adult Non-Fiction Non-Fiction Area

On Order



* Gives programmers, software developers, and advanced users of Microsoft Office applications all the key concepts necessary to write VBA programs for the new Office "X"
* Fully updated to cover all the changes in the newest release of Office
* VBA (Visual Basic for Applications) is the primary development tool for all applications in the Microsoft Office suite-Access, Excel, and Word-and according to Microsoft, more than 2.6 million programmers currently use VBA
* Since VBA is also licensed to other software developers and vendors, it is built into some non-Microsoft, third-party software; programs that include VBA can be tailored to fit specific business needs
* Shows programmers how to build applications with VBA and covers all the essentials, including: VBA visual programming tools, recording and modifying macros, basic VBA programming, running VBA programs, using the VBA Editor, debugging and error trapping, plus more advanced topics, such as built-in VBA commands and working with objects
* Author has written and/or cowritten more than fifty-eight technology books

Author Notes

John Paul Mueller is a technical editor and consultant. He has authored or coauthored 58 books and more than 200 articles on everything from database management to artificial intelligence.

Table of Contents

Part I An Overview of VBA
Chapter 1 Getting to Know VBA
Chapter 2 Your First VBA Program
Part II Learning the Ropes
Chapter 3 Writing Structured VBA Programs
Chapter 4 Storing and Modifying Information
Chapter 5 Creating Structured Programs
Chapter 6 Trapping Errors and Squashing Bugs
Chapter 7 Interacting with the User
Part III Expanding Your VBA Horizons
Chapter 8 Object -Oriented Programming
Chapter 9 Working with Arrays and Collections
Chapter 10 Working with Disk Files
Chapter 11 VBA Programming with XML
Part IV Programming for Applications
Chapter 12 VBA Programming in Office
Chapter 13 VBA Programming in Word
Chapter 14 VBA Programming in Excel
Chapter 15 VBA Programming in Access
Chapter 16 Applications that Work Together
Part V The Part of Tens
Chapter 17 Ten Kinds of VBA Resources
Chapter 18 Ten Ways to Update Your Old VBA Code Quickly
On the Web
Chapter 1 VBA Programming in Front Page
Chapter 2 VBA Programming in Visio
Chapter 3 Ten Really Cool Things You Can Do with VBA