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
Thanks Stephen
I go to http://www.amazon.co.uk this week to order it.
Most appreciated Stephen. Will buy book.
Sounds like required reading! Thanks Stephen.
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.
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 ;-) )…
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