This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. Acknowledgements, Introduction, Primer in Excel VBA, The Application Object, Workbooks and Worksheets, Using Ranges, Using Names, Data Lists, PivotTables, Charts, Event Procedures, Adding Controls, Text Files and File Dialog, Working with XML and the Open XML File Formats, User Forms, Ribbon X, Class Modules, Add-Ins, Automation Add-Ins and COM Add-Ins, Interacting with Other Office Applications, Data Access with ADO, Managing External Data, The Trust Center and Document Security, Browsing OLAP Data Sources with Excel, Excel and the Internet, International Issues, Programming the VBE, Programming with the Windows API, Index.