Hansen Steven M. Mastering Excel 2003 Programming with VBA

Sybex, 2004. — 606 p.Introduction to Excel Development.
Excel as a Development Platform.
Getting to Know Your Environment.
Getting Started with VBA.
Debugging Tactics that Work.
Mastering the Excel Object Model.
Exploring the Application Object.
Working with the Workbook Object.
Winning with Worksheets.
The Most Important Object.
Practical Range Operations.
Exploring Other Excel Objects.
Advanced Excel Programming Techniques.
Developing Class Modules.
Adding User Personalization to Your Application.
Excel Development Best Practices.
Working with External Data.
Integrating with Other Applications.
Incorporating Text Files in Your Solution.
Dealing with Databases.
XL(M) = XML.
Enhancing the End User Experience.
Basic User Interfaces.
Taking Control of Command Bars.
User Form Construction.
One Smart Cookie: Smart Documents with Excel 2003.
Application Deployment Strategies.