Acknowledgments.

Introduction.

Chapter 1: Primer in Excel VBA.

Chapter 2: Programming in the VBE.

Chapter 3: The Application Object.

Chapter 4: Object-Oriented Theory and VBA.

Chapter 5: Event Procedures.

Chapter 6: Class Modules.

Chapter 7: Writing Bulletproof Code.

Chapter 8: Debugging and Testing.

Chapter 9: UserForms.

Chapter 10: Adding Controls.

Chapter 11: Data Access with ADO.

Chapter 12: Creating and Using Add-ins.

Chapter 13: Automation Addins and COM Addins.

Chapter 14: Customizing the VBE.

Chapter 15: Interacting with Other Office Applications.

Chapter 16: Programming with the Windows API.

Chapter 17: International Issues.

Chapter 18: Workbooks and Worksheets.

Chapter 19: Using Ranges.

Chapter 20: Using Names.

Chapter 21: Working with Lists.

Chapter 22: PivotTables.

Chapter 23: Filtered Lists.

Chapter 24: Generating Charts.

Chapter 25: Office Files and Folders.

Chapter 26: Command Bars.

Chapter 27: SmartTags.

Chapter 28: Excel and the Internet.

Chapter 29: XML and Excel.

Appendix A: Excel 2003 Object Model.

Appendix B: VBE Object Model.

Appendix C: VBE Object Model.

Index.