Bovey Rob, Wallentin Dennis et al. Professional Excel Development

2nd Edition. — Pearson Education, Inc., 2009. — 1117 p.Application Architectures
Excel and VBA Development Best Practices
Worksheet Design
Function, General, and Application-Specific Add-ins
Dictator Applications
Using Class Modules to Create Objects
Advanced Command Bar Handling
Introduction to XML
The Office 2007 Ribbon User Interface
Creating Cross-Version Applications
Understanding and Using Windows API Calls
UserForm Design and Best Practices
Interfaces
VBA Error Handling
VBA Debugging
Optimizing VBA Performance Measuring Performance.
Introduction to Database Development
Programming with Access and SQL Server
Data Manipulation Techniques
Advanced Charting Techniques
Controlling Other Office Applications
Excel and Visual Basic 6
Excel and VB.NET
Writing Managed COM Add-ins with VB.NET
Developing Excel Solutions with Visual Studio Tools for Office System (VSTO)
XLLs and the C API
Excel and Web Services
Providing Help, Securing, Packaging, and Distributing Providing Help.