《Excel 2007 Power Programming with VBA》CHM [推广有奖]

0关注
2粉丝

硕士生

38%

还不是VIP/贵宾

威望: 0 级
论坛币: 834 个
通用积分: 1.1934
学术水平: 3 点
热心指数: 8 点
信用等级: 1 点
经验: 24558 点
帖子: 147
精华: 0
在线时间: 127 小时
注册时间: 2007-4-16
最后登录: 2019-12-18

楼主

wise 发表于 2010-3-29 09:53:17 |只看作者 |坛友微信交流群|倒序 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

《Excel 2007 Power Programming with VBA》CHM

作者: John Walkenbach

这套书涉及软件在统计、财务、审计、会计、行政办公等工作中的实际应用,以实例为载体，着重介绍软件的操作功能和实践应用技巧。版本最新，是目前市场上第一套用Excel 2007 来讲述行政办公、财务、会计、审计应用的书。软件与职业应用相结合，契合市场需求。

主要介绍了Excel中VBA(Visual Basic Application)的基础知识，如何录制简单的宏，认识VBA中的对象、方法、属性、变量、常量、控制语句及宏的安全性设定等。从第3章开始，每章有一个实例，不同范例中以不同的方式使用控制语句、窗体、控件等基础知识，巩固并加深读者对VBA的理解和操控，从而达到根据个人实际需要充分发挥VBA的威力、提高工作效率的目的。.
本书精心设计的范例是作者多年工作经验的积累总结，非常实用，读者只要通过简单的“移植”，结合自己实际工作需要，修改代码中的相应内容，就可以轻松解决工作、生活、学习中所遇到的类似问题。

Contents at a Glance
Preface vii
Part I: Some Essential Background
Chapter 1: Excel 2007: Where It Came From 3
Chapter 2: Excel in a Nutshell 15
Chapter 3: Formula Tricks and Techniques 47
Chapter 4: Understanding Excel’s Files 73
Part II: Excel Application Development
Chapter 5: What Is a Spreadsheet Application? 97
Chapter 6: Essentials of Spreadsheet Application Development 109
Part III: Understanding Visual Basic for Applications
Chapter 7: Introducing Visual Basic for Applications 133
Chapter 8: VBA Programming Fundamentals 189
Chapter 9: Working with VBA Sub Procedures 237
Chapter 10: Creating Function Procedures 275
Chapter 11: VBA Programming Examples and Techniques 315
Part IV: Working with UserForms
Chapter 12: Custom Dialog Box Alternatives 389
Chapter 13: Introducing UserForms 413
Chapter 14: UserForm Examples 449
Chapter 15: Advanced UserForm Techniques 487
Part V: Advanced Programming Techniques
Chapter 16: Developing Excel Utilities with VBA 533
Chapter 17: Working with Pivot Tables 555
Chapter 18: Working with Charts 571
Chapter 19: Understanding Excel’s Events 629
Chapter 20: Interacting with Other Applications 669
Chapter 21: Creating and Using Add-Ins 699
Part VI: Developing Applications
Chapter 22: Working with the Ribbon 727
Chapter 23: Working with Shortcut Menus 761
Excel 2007 Power Programming with VBA
Chapter 24: Providing Help for Your Applications 781
Chapter 25: Developing User-Oriented Applications 801
Part VII: Other Topics
Chapter 26: Compatibility Issues 817
Chapter 27: Manipulating Files with VBA 829
Chapter 28: Manipulating Visual Basic Components 859
Chapter 29: Understanding Class Modules 885
Chapter 30: Working with Colors 901
Chapter 31: Frequently Asked Questions about Excel Programming 929
Part VIII: Appendixes
Appendix A: Excel Resources Online 971
Appendix B: VBA Statements and Functions Reference 977
Appendix C: VBA Error Codes 989
Appendix D: What’s on the CD-ROM 993
Index

详细地址请看：
http://www.exceltip.net/thread-172-1-5-232.html