Pro Excel 2007 VBA

Table of contents

1. Title Page
2. Dedication
3. Contents at a Glance
4. Contents
5. About the Author
6. About the Technical Reviewer
7. Acknowledgments
8. Introduction
   1. Who This Book Is For
   2. How This Book Is Structured
   3. Prerequisites
   4. Downloading the Code
   5. Contacting the Author
9. CHAPTER 1: The Macro Recorder and Code Modules
   1. Macro Security Settings
   2. The Visual Basic Development Environment
   3. Recording a Macro
   4. Writing a Macro in the VBE
   5. The Object Browser
   6. Standard Code Modules
   7. Class Modules
   8. UserForms
   9. Object-Oriented Programming: An Overview
   10. Summary
10. CHAPTER 2: Data In, Data Out
    1. Excel's Data Import Tools
    2. Using DAO in Excel 2007
    3. Using ADO in Excel 2007
    4. Of Excel, Data, and Object Orientation
    5. Summary
11. CHAPTER 3: Using XML in Excel 2007
    1. Importing XML in Excel 2007
    2. Appending XML Data
    3. Saving XML Data
    4. Building an XML Data Class
    5. Adding a Custom Ribbon to Your Workbook
    6. Summary
12. CHAPTER 4: UserForms
    1. Creating a Simple Data Entry Form
    2. Creating Wizard-Style Data Entry UserForms
    3. Summary
13. CHAPTER 5: Charting in Excel 2007
    1. Getting Started
    2. Summarizing with Pie Charts
    3. Summary
14. CHAPTER 6: PivotTables
    1. Putting Data into a PivotTable Report
    2. Summary
15. CHAPTER 7: Debugging and Error Handling
    1. Debugging
    2. Error Handling
    3. Summary
16. CHAPTER 8: Office Integration
    1. Creating a Report in Word
    2. Creating a PowerPoint Presentation
    3. Summary
17. CHAPTER 9: ActiveX and .NET
    1. Using ActiveX Components in Your Excel 2007 Projects
    2. Excel in the .NET World
    3. Summary
18. Index