Ebook: Excel 2007 VBA programmer's reference

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 -- UserForms -- RibbonX -- Command bars -- 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 -- Appendix A: Excel 2007 object model -- Appendix B: VBE object model -- Appendix C: Office 2007 object model