![]() |
Table of Contents
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. |
![]() |