Introduction

The Excel 2007 VBA Programmer's Reference is a beginner-intermediate level guide to using VBA with Excel. It starts with a VBA Primer, which is applicable to the strong beginner and those who have programmed before but are new to VBA. It goes on to explain how to use VBA to control the main parts of Excel, from manipulating Ranges to creating Addins. It then introduces some more advanced topics, from creating Addins using Visual Basic to programming with the Windows API. The book ends with three large appendices that list all the objects in the Excel, VBE and Office object models, with their properties, methods and many code samples of their usage.

Chapter 14 - RibbonX (pdf) is provided as a sample chapter, explaining how to control the Excel 2007 Ribbon using VBA. Reproduced here with the kind permission of Wrox Press.

All four authors are professional Excel developers who run our own companies developing Excel-based applications for clients ranging from individuals to the largest multinational corporations.

This edition has been comprehensively updated for Excel 2007, including many completely new and rewritten chapters, explaining how to manipulate the Excel 2007 XML file formats, how to master the Ribbon and all the new external data and security enhancements.

Table of Contents

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries