Ribbon On The Fly Part2

Microsoft sneaked a couple of ne Introduction In my last blog post, I described how I thought that I could build an Excel 2007 ribbon on th fly. The technique was founded upon having a ‘worker’ addin that handled the main functionality as well as the version management and ribbon building; and a simpler Excel 2007 ribbon wrapper addin. This approach would be similar to the myriad of table driven menu solutions around, but the ‘table’ would be a configuration file in this case, to allow the user to control the menu/ribbon. The ‘worker’ addin would read the configuration file … Continue reading Ribbon On The Fly Part2

Deploy Me Simple

Excel 2003 Addins In Excel 2007 Excel 2007 and 2010 is so different in concept to Excel 2003 and before that there are many new challenges in providing solutions that can be deployed in either version. One challenge that I have been faced with is creating addins that may be used in Excel 2007 or earlier versions. My addins would usually have a menu and/or a toolbar to provide access to the functionality within the addin. In previous versions of Excel, this has been an elegant solution as most people are familiar with the menus and are easily able to … Continue reading Deploy Me Simple

Ribbons – Gain Without The Pain

Normal 0 false false false MicrosoftInternetExplorer4 If you are in the habit of building or customising Excel 2007 Ribbons, there is an indispensable new tool that has just hit the market. Andy Pope has released his RibbonX Visual Designer, which can be found here.   I have blogged previously about how I find cutting XML tedious, and the inadequate tools available, so this is a more than useful addition to make ribbon design and coding simpler. It provides a GUI to facilitate the Ribbon build, simple point and click rather than the tedious line coding. The big advantage of this … Continue reading Ribbons – Gain Without The Pain

Autogen’ed Ribbon Code

Normal 0 false false false MicrosoftInternetExplorer4 In a previous post, XML Is Such A Pain, I showed the technique that I use to simplify the creation of XML code for custom ribbons. This is a handy technique, as it means that creating the XML is very simple, it is more or less a cut-and-paste job, and I spend very little time thereafter  with the XML, which I like as the tools for XML in Excel 2007 are not great. As much as I like this technique, it still requires a lot of VBA code. Whilst VBA is a great deal … Continue reading Autogen’ed Ribbon Code

XML Is Such A Pain

Normal 0 false false false Creating a custom ribbon tab in Excel 2007 is a well known technique by now, and relatively easy to achieve.  I will not go into the details here, there are many examples scattered across the web, I would suggest Ron de Bruin’s pages at http://www.rondebruin.nl/ribbon.htm. The biggest pain for me with custom ribbon code is the XML. As an example, to create a custom ribbon tab such as this requires the following XML code <customUI xmlns=”http://schemas.microsoft.com/office/2006/01/customui” onLoad=”rxDemoRibbonOnLoad”> <ribbon startFromScratch=”false”> <tabs> <tab id=”tabDemo” getLabel=”Ribbon Demo” insertAfterMso=”TabHome”> <group id=”grpDemoGroup1″ getLabel=”Formatting Group”> <button id=”btnDemoButton1″ label=”Currency” image=”DollarSign” imageSize=”Large” screentip=”Button … Continue reading XML Is Such A Pain