Excel 2007 VBA Programmer's Reference

DESCRIPTION

Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications.
Begins with an overview of VBA, the programming language for the Microsoft Office suite and many other applications, which allows users to do anything from automating Excel tasks to developing full applications with Excel as the development environment.
The book then expands to focus on major issues faced by advanced Excel users and developers, such as setting up applications and converting them to add-ins, packaging and distributing Excel applications, and advanced debugging and handling techniques.
Features a reference section downloadable from the Web for easy perusal.

Table of Contents
Acknowledgements.
Introduction.

Chapter 1: Primer in Excel VBA.

Chapter 2: The Application Object.

Chapter 3: Workbooks and Worksheets.

Chapter 4: Using Ranges.

Chapter 5: Using Names.

Chapter 6: Filtered Lists.

Chapter 7: PivotTables.

Chapter 8: Charts.

Chapter 9: Event Procedures.

Chapter 10: Adding Controls.

Chapter 11: Text Files and File Dialog.

Chapter 12: Working with XML and the Open XML File Formats.

Chapter 13: UserForms.

Chapter 14: RibbonX.

Chapter 15: Command Bars.

Chapter 16: Class Modules.

Chapter 17: Add-ins.

Chapter 18: Automation Add-ins and COM Add-ins.

Chapter 19: Interacting with Other Office Applications.

Chapter 20: Data Access with ADO.

Chapter 21: Managing External Data.

Chapter 22: The Trust Center and Document Security.

Chapter 23: Browsing OLAP Data Sources with Excel.

Chapter 24: Excel and the Internet.

Chapter 25: International Issues.

Chapter 26: Programming the VBE.

Chapter 27: Programming with the Windows API.

Appendix A: Excel 2002 Object Model

Appendix B: VBE Object Model.

Appendix C: Office 2007 Object Model.

Index.