《熟练掌握微软 Office 2010 VBA》文字版

基本信息

• 书籍大小：未知
• 书籍语言：简体中文
• 书籍类别：办公应用
• 书籍标签：办公应用
• 购买链接： 京东   淘宝

打开支付宝首页搜“673273051”领红包，领到大红包的小伙伴赶紧使用哦！

相关书籍

• 《office技巧1000例，不管是学生还是办公总有需用的时候 》[]
• 《电脑印前图文处理800问 高清扫描版》[]
• 《Word+Excel+PowerPoint 2013办公应用_顾永湘_东南大学》[]
• 《最新office2010高效办公三合一》[]
• 《Office2010办公应用从入门到精通》电子书[]
• 《WORD／EXCEL／POWERPOINT2010办公应用实战》全彩电子书[]
• 《学Office2007办公应用》高清文字版[]
• 《24小时学会OFFICE 2010》彩图电子书[]
• 《计算机基础：WindowsXP+Office2003》高清文字版[]

内容介绍

下面是学习资料下载列表，您可以点击这些文件名进行下载，如果不能下载，请查看下载帮助
	[熟练掌握微软.Office.2010.VBA].Sybex.Mastering.VBA.for.Office.2010.Aug.2010.pdf	11.91MB
全选

中文名: 熟练掌握微软 Office 2010 VBA
原名: Mastering VBA for Microsoft Office 2010
作者: Richard Mansfield
图书分类: 软件
资源格式: PDF
版本: 文字版
出版社: Wiley Publishing, Inc
书号: ISBN: 978-0-470-63400-4
发行时间: 2010年8月
地区: 美国
语言: 英文
简介:

目录:

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii
Part 1 • Recording Macros and Getting Started with VBA . . . . . . . . . . . . . . . . . . . . 1
Chapter 1 • Recording and Running Macros in the
Offi ce Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Chapter 2 • Getting Started with the Visual Basic Editor. . . . . . . . . . . . . . . . . . . . . . . . 31
Chapter 3 • Editing Recorded Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
Chapter 4 • Creating Code from Scratch in the Visual Basic Editor . . . . . . . . . . . . . . . 87
Part 2 • Learning How to Work with VBA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
Chapter 5 • Understanding the Essentials of VBA Syntax . . . . . . . . . . . . . . . . . . . . . . 107
Chapter 6 • Working with Variables, Constants, and Enumerations . . . . . . . . . . . . . 123
Chapter 7 • Using Array Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145
Chapter 8 • Finding the Objects, Methods, and Properties You Need . . . . . . . . . . . . 167
Part 3 • Making Decisions and Using Loops and Functions . . . . . . . . . . . . . . . . . .191
Chapter 9 • Using Built-in Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
Chapter 10 • Creating Your Own Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
Chapter 11 • Making Decisions in Your Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245
Chapter 12 • Using Loops to Repeat Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265
Part 4 • Using Message Boxes, Input Boxes, and Dialog Boxes . . . . . . . . . . . . . . . 293
Chapter 13 • Getting User Input with Message Boxes and Input Boxes. . . . . . . . . . . 295
Chapter 14 • Creating Simple Custom Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
Chapter 15 • Creating Complex Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 381
Part 5 • Creating Effective Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 429
Chapter 16 • Building Modular Code and Using Classes. . . . . . . . . . . . . . . . . . . . . . . 431
Chapter 17 • Debugging Your Code and Handling Errors. . . . . . . . . . . . . . . . . . . . . . 457
Chapter 18 • Building Well-Behaved Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487
Chapter 19 • Securing Your Code with VBA’s Security Features . . . . . . . . . . . . . . . . 501
Part 6 • Programming the Offi ce Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . 525
Chapter 20 • Understanding the Word Object Model and Key Objects . . . . . . . . . . . 527
Chapter 21 • Working with Widely Used Objects in Word . . . . . . . . . . . . . . . . . . . . . 559
Chapter 22 • Understanding the Excel Object Model and Key Objects . . . . . . . . . . . 591
Chapter 23 • Working with Widely Used Objects in Excel . . . . . . . . . . . . . . . . . . . . . . 617
Chapter 24 • Understanding the PowerPoint Object Model and Key Objects . . . . . . 631
Chapter 25 • Working with Shapes and Running Slide Shows . . . . . . . . . . . . . . . . . . 653
Chapter 26 • Understanding the Outlook Object Model and Key Objects. . . . . . . . . 673
Chapter 27 • Working with Events in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 693
Chapter 28 • Understanding the Access Object Model and Key Objects . . . . . . . . . . 713
Chapter 29 • Manipulating the Data in an Access Database via VBA . . . . . . . . . . . . 735
Chapter 30 • Accessing One Application from Another Application. . . . . . . . . . . . . 755
Chapter 31 • Programming the Offi ce 2010 Ribbon. . . . . . . . . . . . . . . . . . . . . . . . . . . . 783
Appendix • The Bottom Line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 811
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 855
Visual Basic for Applications (VBA) is a powerful tool that enables you to automate operations in the Microsoft Office applications and in other applications that host VBA. By automating operations using VBA, you can save yourself and your colleagues huge amounts of time and effort. Getting more work done in less time is usually good for your disposition and self-esteem, and it can do wonderful things for your job security and career.
This book shows you how to program VBA, using the Microsoft Office 2010 applications for specific examples. You can apply the principles you learn in this book to any other VBA-enabled application as well.

下载地址