Excel 2003 VBA Programmer's Reference (0764556606) cover image

Excel 2003 VBA Programmer's Reference

Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson (Contributions by)
ISBN: 978-0-7645-5660-9
Paperback
1176 pages
July 2004
This title is out-of-print and not currently available for purchase from this site.
About This Title  |  Download Code  |  Errata  |  P2P Forum for This Title
About the Authors.

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.