文件名称：Excel 2003 VBA Programmer's Reference.pdf
文件大小：18.09MB
文件格式：PDF
更新时间：2011-12-31 06:44:50
Excel 2003 VBA
Chapter 1: Primer in Excel VBA Chapter 2: Programming in the VBE 63 Chapter 3: The Application Object 75 Chapter 4: Object-Oriented Theory and VBA 89 Chapter 5: Event Procedures 103 Chapter 6: Class Modules 113 Chapter 7: Writing Bulletproof Code 127 Chapter 8: Debugging and Testing 151 Chapter 9: UserForms 167 Chapter 10: Adding Controls 183 Chapter 11: Data Access with ADO 197 Chapter 12: Creating and Using Add-ins 245 Chapter 13: Automation Addins and COM Addins 253 Chapter 14: Customizing the VBE 281 Chapter 15: Interacting with Other Office Applications 313 Chapter 16: Programming with the Windows API 327 Chapter 17: International Issues 359 Chapter 18: Workbooks and Worksheets 393 Chapter 19: Using Ranges 409 Chapter 20: Using Names 441 Chapter 21: Working with Lists 453 Chapter 22: PivotTables 463 Chapter 23: Filtered Lists 483 Chapter 24: Generating Charts 497 Chapter 25: Office Files and Folders 515 Chapter 26: Command Bars 531 Chapter 27: SmartTags 571 Chapter 28: Excel and the Internet 597 Chapter 29: XML and Excel 629