VBA and Macros for Microsoft Excel

Table of Contents

1. Title Page
2. Copyright Page
3. Contents at a Glance
4. Contents
5. About the Authors
6. Dedication
7. Acknowledgments
8. We Want to Hear from You!
9. Introduction
10. I First Steps up the VBA Learning Curve
    1. 1 Unleash the Power of Excel with VBA!
    2. 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar?
    3. 3 Referring to Ranges
    4. 4 User-Defined Functions
    5. 5 Looping and Flow Control
    6. 6 R1C1 Style Formulas
    7. 7 Names
    8. 8 Event Programming
    9. 9 UserForms—An Introduction
11. II Automating Excel Power in VBA
    1. 10 Charts
    2. 11 Data Mining with Advanced Filter
    3. 12 Pivot Tables
    4. 13 Excel Power
    5. 14 Reading from and Writing to the Web
    6. 15 XML in Excel 2003 Professional
    7. 16 Automating Word
12. III Techie Stuff You Will Need to Produce Applications for the Administrator to Run
    1. 17 Arrays
    2. 18 Text File Processing
    3. 19 Using Access as a Back End to Enhance Multi-User Access to Data
    4. 20 Creating Classes, Records, and Collections
    5. 21 Advanced UserForm Techniques
    6. 22 Windows Application Programming Interface (API)
    7. 23 Handling Errors
    8. 24 Using Custom Menus to Run Macros
    9. 25 Add-Ins
    10. 26 Case Study: Designing an Excel Application
13. Index