Search and Find
Service
Contents at a Glance
5
Contents
6
About the Author
10
About the Technical Reviewer
11
Acknowledgments
12
Introduction
13
Who This Book Is For
13
How This Book Is Structured
13
Prerequisites
14
Downloading the Code
15
Contacting the Author
15
The Macro Recorder and Code Modules
16
Macro Security Settings
16
The Visual Basic Development Environment
19
Recording a Macro
29
Writing a Macro in the VBE
35
The Object Browser
39
Standard Code Modules
42
Class Modules
44
UserForms
51
Object- Oriented Programming: An Overview
54
Summary
56
Data In, Data Out
57
Excel’s Data Import Tools
57
Using DAO in Excel 2007
68
Using ADO in Excel 2007
81
Of Excel, Data, and Object Orientation
101
Summary
110
Using XML in Excel 2007
112
Importing XML in Excel 2007
112
Appending XML Data
119
Saving XML Data
120
Building an XML Data Class
121
Adding a Custom Ribbon to Your Workbook
132
Summary
145
UserForms
146
Creating a Simple Data Entry Form
146
Creating Wizard- Style Data Entry UserForms
163
Summary
204
Charting in Excel 2007
205
Getting Started
205
Summarizing with Pie Charts
214
Summary
233
PivotTables
234
Putting Data into a PivotTable Report
234
Summary
258
Debugging and Error Handling
259
Debugging
259
Error Handling
285
Summary
295
Office Integration
297
Creating a Report in Word
297
Creating a PowerPoint Presentation
308
Summary
324
ActiveX and .NET
325
Using ActiveX Components in Your Excel 2007 Projects
325
Excel in the . NET World
333
Summary
360
Index
361
All prices incl. VAT