Excel^® 2007 VBA Programmer's Reference

by John Green; Stephen Bullen; Rob Bovey; Michael Alexander (McKinney, TX)

• ISBN13: 9780470144220
• ISBN10: 047014422X
• Copyright: 2007-06-01
• Publisher: Wrox

Summary

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.

Table of Contents

Acknowledgements

Introduction

Primer in Excel VBA

The Application Object

Workbooks and Worksheets

Using Ranges

Using Names

Filtered Lists

PivotTables

Charts

Event Procedures

Adding Controls

Text Files and File Dialog

Working with XML and the Open XML File Formats

User Forms

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

Excel 2002 Object Model

VBE Object Model

Office 2007 Object Model

Index

Table of Contents provided by Publisher. All Rights Reserved.