Home | Live Training| Excel Tutorials | Access Tutorials | Xcelsius Tutorials | Freeware | About  

Excel 2007 VBA Programmer's Reference
Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed squarely at Excel users who want to start using VBA to improve processes and develop Excel applications.   This book will no doubt become a well-thumbed resource for all levels of Excel user.  Topics covered in this book are as follows:

  • 1:  Primer in Excel VBA

  • 16:  Class Modules

  • 2:  The Application Object

  • 17:  Add-ins

  • 3:  Worrkbooks and Worksheets

  • 18:  Automation Add-ins and COM Add-ins

  • 4:  Using Ranges

  • 19:   Interacting with Other Office Applications

  • 5:   Using Names

  • 20:  Data Access with ADO

  • 6:  Filtered Lists

  • 21:  Managing External Data

  • 7:  Pivot Tables

  • 22: The Trust Center and Document Security

  • 8:  Generating Charts

  • 23:  Browsing OLAP Data Sources with Excel

  • 9:  Event Procedures

  • 24:  Excel and the Internet

  • 10:  Adding Controls

  • 25:  International Issues

  • 11:  Text Files and File Dialog

  • 26:  Programming the VBE

  • 12:  Working with XML and the Open XML File Formats

  • 27:  Programming with the Windows API

  • 13:  Userforms

  • Appendix A:  Excel 2002 Object Model

  • 14:  The Ribbon

  • Appendix B:  VBE Object Model

  • 15:  Command Bars
  • Appendix C:  Office XP Object Model

 

Now Available

 

Sample Chapter

Chapter 14: Ribbon X

 

 
© Copyright 2004-2009  DataPig Technologies LLC. All rights reserved.