Cover image for Pro Excel 2007 VBA

Pro Excel 2007 VBA

Author Jim DeMarco
Release Date: 2008/03/01
ISBN: 9781590599570
Topic:
0%
20
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object-oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development.

This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the Visual Basic for Applications story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion. Bon voyage!

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
18.116.85.72