Pro Excel 2007 VBA (eBook)

A bio is not available for this author.

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