Office XP Development With VBA

by Peter G. Aitken

Published by Prentice Hall PTR, September 2001
510 pages, $49.99
ISBN 0-13-065417-5

"...provides just the right amount of information and frankly is one of the best introductory and intermediate VBA books I've read. Required reading  for new and intermediate VBA developers." Donna Payne, Microsoft Office Solutions Magazine, June, 2002.

Order from

View corrections

Source code

Email the author

Table of Contents

Part 1: Getting Started.

Chapter 1. Why Develop With Office and VBA?
Chapter 2.
The Basics of Office Development.
Chapter 3.
Visual Basic for Applications - the Fundamentals.
Chapter 4.
Working With Office Objects.

Part 2: The Office Components.  

Chapter 5. Using Word Components.
Chapter 6. Using Excel Components.
Chapter 7. Using Data Access Components.
Chapter 8. Using PowerPoint Components.
Chapter 9. Using FrontPage Components.
Chapter 10. Using Outlook Components.
Chapter 11. Using the Shared Office Components.

 Part 3. Visual Basic for Applications.

Chapter 12. Data Storage and Operators.
Chapter 13.
Conditional and Loop Statements.
Chapter 14.
Writing Procedures.
Chapter 15.
Working With Strings.
Chapter 16.
Working with Dates and Times.
Chapter 17. Working With
Chapter 18.
Creating Custom Classes and Objects.
Chapter 19.
Creating User Forms.

 Part 4:  Other Office Development Tools.

Chapter 20. VBA Error Handling.
Chapter 21. Debugging, Deploying, and Supporting Your Application.
Chapter 22. Using the Windows API and Registry.
Chapter 23. Office Technologies for the Web. 

Part 5: Putting it All to Work.

Chapter 24. Web Publishing of a Multi-author Compound Document.
Chapter 25. Numeric Processing and Graphing.
Chapter 26. Database Report Generation.

Source Code

Click the link below to download This archive contains a text file for each of the book's numbered listings. Once you have extracted these files you can copy code into your Office XP prpojects.



Page 112

In the last listing of the page I mistakenly used the Height and Width properties of a Range object. These properties give the size of the range in screen units, not the number of rows and columns in the range. The loop in the code should be changed as follows to correctly iterate through all the rows and columns in the range:

For row = 1 to r.Rows.Count
  For col = 1 to r.Columns.Count

Page 126

In the bulleted list, the text Table 0, Table 1, etc. should be deleted.