Wrox Home  
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
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.



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.


Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free