Wiley.com
Print this page Share

Excel 2007 VBA Programmer's Reference

ISBN: 978-0-470-04643-2
Paperback
1176 pages
March 2007
Excel 2007 VBA Programmer's Reference (0470046430) cover image
This title is out-of-print and not currently available for purchase from this site.

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.

Related Titles

More By These Authors

General

by Bill Sempf, Peter Jausovec
by Denise M. Gosnell
by John Walkenbach, Herb Tyson, Faithe Wempen, Cary N. Prague, Michael R. Groh, Peter G. Aitken, Michael R. Irwin, Gavin Powell, Lisa A. Bucki
by John Paul Mueller, Debbie Walkowski
by Shahar Prish
Back to Top