RibbonX Sample Chapter from Excel 2007 VBA Programmer’s Reference

The Excel 2007 VBA Programmer’s Reference is now on its way to the printers, due to hit the shelves on March 19th. John Green, Rob Bovey, Michael Alexander and I have been working hard with Excel 2007 to write this update to the 2002 edition. Most of the chapters have been significantly revised and we have written completely new chapters on Lists, Charts, the XML file formats, RibbonX, Data Access, Managing External Data, OLAP Data Sources and the Trust Center. To whet your appetite, Wrox Press has kindly given me permission to make the RibbonX chapter available for download from my web site. That chapter goes into quite a bit of detail about how to set up and manipulate the Ribbon using VBA.

Enjoy,

Stephen Bullen

Posted in Uncategorized

6 thoughts on “RibbonX Sample Chapter from Excel 2007 VBA Programmer’s Reference

  1. Thanks Stephen.

    I didn’t see anything on how to integrate a Ribbon into a COM Add-in. In my case, I’m still using VB6. Anyone know a good article or resource that provides a little hand holding on that topic?

    Thanks.

  2. Bearing in mind I have no immediate plans to upgrade to 2007, I seem to be buying my fair share of 2007 books (I’ve ordered my copy already ;-) )…

  3. Nicholas: “I didn’t see anything on how to integrate a Ribbon into a COM Add-in. In my case, I’m still using VB6. Anyone know a good article or resource that provides a little hand holding on that topic?”

    That’s included in the COM Addins chapter (#18)!

    Regards

    Stephen Bullen


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.