Excel® 2007 VBA Programmer's Reference
by John Green; Stephen Bullen; Rob Bovey; Michael Alexander (McKinney, TX)Pub. Date: 2007-06-01
Publisher(s): Wrox
Availability: This title is currently not available.
Other versions by this Author
List Price: $39.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.