The Macro Recorder and Code Modules; Data In, Data Out; Using XML in Excel 2007; UserForms; Charting in Excel 2007; PivotTables; Debugging and Error Handling; Office Integration; ActiveX and .NET.
Summary
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.