Office XP Development With VBA
by Peter G. Aitken
Published by Prentice Hall PTR, September 2001
510 pages, $49.99
"...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 Amazon.com
Email the author
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.
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.
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 Files.
Chapter 18. Creating Custom Classes and Objects.
Chapter 19. Creating User Forms.
Chapter 21. Debugging, Deploying, and Supporting Your Application.
Chapter 22. Using the Windows API and Registry.
Chapter 23. Office Technologies for the Web.
Publishing of a Multi-author Compound Document.
Chapter 25. Numeric Processing and Graphing.
Chapter 26. Database Report Generation.
Click the link below to download OfficeXP_Listings.zip. 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.
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
In the bulleted list, the text Table 0, Table 1, etc. should be deleted.