Show TOC

Ribbon Extensions: Simple MethodLocate this document in the navigation structure

You can create extensions to the Ribbon in a simple way, using an .xml file and Microsoft Office Excel macros.

This section provides detailed information on how to extend the EPM tab of the Microsoft Office Excel Ribbon when using SAP BusinessObjects Analysis, edition for Microsoft Office.

Main Steps
  1. Create a file called RibbonXML.xml and store it in \%userprofile%\AppData\Local\EPMOfficeClient\
  2. Create a Microsoft Excel EPM plug-in file containing the macros.
  3. The Ribbon is automatically updated with your extensions. Your extensions are added to the right part of the EPM tab of the Ribbon.
Note
  • So that the extensions are loaded each time you open a Microsoft Excel workbook, save the file containing the macros, as an .xla file and add the file as an plug-in to Excel. If you do this, you must write each macro name in the RibbonXML.xml file as follows: myFile.xla!myMacro
  • The name of the extension is also displayed in the About box that you can access by selecting Start of the navigation path About Next navigation step About EPM plug-in End of the navigation path from the EPM tab.