Excel 2007 VBA Programmer's Reference (0470046430) cover image

Excel 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
ISBN: 978-0-470-04643-2
Paperback
1176 pages
March 2007
Other Available Formats: E-book
If you are an instructor, you may request an evaluation copy for this title.
Paperback Version: US $39.99 Add to Cart

About This Title  |  Download Code  |  Errata  |  P2P Forum for This Title
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.