简介
A comprehensive guide to the language used to customizeMicrosoft Office
Visual Basic for Applications (VBA) is the language used forwriting macros, automating Office applications, and creating customapplications in Word, Excel, PowerPoint, Outlook, and Access. Thiscomplete guide shows both IT professionals and novice developershow to master VBA in order to customize the entire Office suite forspecific business needs.
Office 2010 is the leading productivity suite, and the VBAlanguage enables customizations of all the Office programs; thiscomplete guide gives both novice and experienced programmers theknowledge they need to make maximum use of VBA for Office
Supported with real-world examples in Word, Excel, PowerPoint,Outlook, and Access, this book offers clear, systematic tutorialswith both intermediate and advanced content
Covers learning how to work with VBA; recording macros; usingloops and functions; using message boxes, input boxes, and dialogboxes; creating effective code; XML-based files; ActiveX; thedeveloper tab; content controls; add-ins; embedded macros; andsecurity
Mastering VBA for Office 2010 prepares developers to customizeall Microsoft Office 2010 applications for the unique needs oftheir employers.
目录
Part I: Recording Macros and Getting Started with VBA.
1 Recording and Running Macros in the Microsoft OfficeApplications.
2 Getting Started with the Visual Basic Editor.
3 Editing Recorded Macros.
4 Creating Code from Scratch in the Visual Basic Editor.
Part II: Learning How to Work with VBA.
5 Understanding the Essentials of VBA Syntax
6 Working with Variables, Constants, and Enumerations.
7 Using Array Variables.
8 Finding the Objects, Methods, and Properties You Need.
Part III: Making Decisions and Using Loops and Functions.
9 Using Built-In Functions.
10 Creating Your Own Functions.
11 Making Decisions in Your Code.
12 Using Loops to Repeat Actions.
Part IV: Using Message Boxes, Input Boxes, and Dialog Boxes.
13 Getting User Input with Message Boxes and Input Boxes.
14 Creating Simple Custom Dialog Boxes.
15 Creating Complex Dialog Boxes.
Part V: Creating Effective Code.
16 Building Modular Code and Using Classes.
17 Debugging Your Code and Handling Errors.
18 Building Well-Behaved Code.
19 Securing Your Code with VBA's Security Features.
Part VI: Programming the Office Applications.
20 Understanding the Word Object Model and Key Objects.
21 Working with Widely Used Objects in Word.
22 Understanding the Excel Object Model and Key Objects.
23 Working with Widely Used Objects in Excel.
24 Understanding the PowerPoint Object Model and KeyObjects.
25 Working with Shapes and Running Slide Shows.
26 Understanding the Outlook Object Model and Key Objects.
27 Working with Events in Outlook.
28 Understanding the Access Object Model and Key Objects.
29 Manipulating the Data in an Access Database via VBA.
30 Accessing One Application from Another Application.
31 Programming the Office 2010 Ribbon.
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
