Details
Author: Walkenbach, John
ISBN:
0-7645-4072-6
Publisher: Wiley Publishing, 2004, 1,020 pp., List price $49.99 (US)
Comments: This is a revision of the best-selling Excel 2002 Power Programming With VBA, updated for Excel 2003. It includes several new examples, all of which are available on the companion CD-ROM. In addition, the CD-ROM includes an electronic version of the book.
Unlike other VBA books, it also covers spreadsheet application development from a broader perspective. It covers many advanced topics, and includes tons of insider tips and useful examples that cannot be found elsewhere.
Table of Contents
Preface
Part I: Some Essential Background
Part I: Some Essential Background
Preface
Part I: Some Essential Background
Part I: Some Essential Background
- Chapter 1: Excel 2003: Where It Came From
- Chapter 2: Excel in a Nutshell
- Chapter 3: Formula Tricks and Techniques
- Chapter 4: Understanding Excel’s Files
Part II: Excel Application Development
- Chapter 5: What Is a Spreadsheet Application?
- Chapter 6: Essentials of Spreadsheet Application Development
Part III: Understanding Visual Basic for Applications
- Chapter 7: Introducing Visual Basic for Applications
- Chapter 8: VBA Programming Fundamentals
- Chapter 9: Working with VBA Sub Procedures
- Chapter 10: Creating Function Procedures
- Chapter 11: VBA Programming Examples and Techniques
Part IV: Working With UserForms
- Chapter 12: Custom Dialog Box Alternatives
- Chapter 13: Introducing UserForms
- Chapter 14: UserForm Examples
- Chapter 15: Advanced UserForm Techniques
Part V: Advanced Programming Techniques
- Chapter 16: Developing Excel Utilities with VBA
- Chapter 17: Working With Pivot Tables
- Chapter 18: Working With Charts
- Chapter 19: Working With Excel's Events
- Chapter 20: Interacting with Other Applications
- Chapter 21: Creating and Using Add-Ins
Part VI: Developing Applications
- Chapter 22: Creating Custom Toolbars
- Chapter 23: Creating Custom Menus
- Chapter 24: Providing Help for Your Applications
- Chapter 25: Developing User-Oriented Applications
Part VII: Other Topics
- Chapter 26: Compatibility Issues
- Chapter 27: Manipulating Files With VBA
- Chapter 28: Manipulating Visual Basic Components
- Chapter 29: Understanding Class Modules
- Chapter 30: Frequently Asked Questions about Excel Programming
Part V: Appendixes
- Appendix A: Excel Resources Online
- Appendix B: VBA Statements and Functions Reference
- Appendix C: VBA Error Codes
- Appendix D: What's On the CD-ROM
鸿篇巨著Excel2003高级VBA编程宝典作者John Walkenbach是享有电子表格软件方面美誉的领导权威,他编写了30多部电子表格方面的书籍。John毕业于密苏里大学,并从蒙大拿大学获得硕士博士学位。
Excel 2003 Power Programming With VBA(内含高级编程示例) 是一本经典。她经得起反复阅读,并且每次阅读都有新的收获和感受。本书内容丰富,适合不同的VBA层次的读者。根据本书的特点和自已的阅读经验,建议不同水平的读者阅读方法如下:
1、对于初学者和刚入门的读者,您可以先阅读学习第3部分,本人觉得对于初学者,该部分绝对是精华,值得反复研读。然后学习用户窗体知识,就是第4部分的第12章、第13章和第14章。接下来,可以学习第19章,理解Excel的事件。最后,是第22章和第23章,来创建自定义工具栏和菜单。
2、对于已有一定VBA编程经验的读者,您可以将上述章节通读一篇,主要是关注作者所介绍的一些方法技巧和经验,然后,再阅读学习VBA编程的高级部分,即用户窗体的高级技巧、操作数据透视表和图表、开发实用程序、与其它应用程序交互、创建和使用加载宏、处理文件和VB组件、以及类模块等方面的知识。
3、对于已熟练掌握VBA编程的读者,通读本书,您也能找到一些好的方法技巧和经验,并且还能作为您的工具书,以备不时之需。
4、在阅读本书时,您要注意总结归纳,例如,语法规则、优秀的示例、好的方法技巧等。我总认为,有总结归纳,基础才能打扎实,才能有更大的收获和提高。
(本帖内含高级编程示例)
1.
说明:此附件为DJVU格式,附带DJVU阅读器
解压方法:按顺序把前三个文件更名为1.rar 2.rar 3.rar然后点击1.rar进行解压缩。
[此贴子已经被作者于2007-12-23 12:03:17编辑过]