Show TOC

How to Create a Ribbon Extension Locate this document in the navigation structure

Prerequisites

Use Microsoft Visual Studio 2008 or 2010. If you use Visual Studio 2010, choose the .NET Framework 3.5.

Procedure

  1. Create an empty class library project.
  2. Set a name that ends with "RibbonExtension".
  3. Add the following .dlls as References in the project:
    • FPMXLClient.RibbonUtilies.dll

      Browse to the folder that contains the EPM plug-in dlls.

    • stdole.dll

      This dll is available in . NET Framework

    • Office.dll V12

      This dll is available in . NET Framework

    • System.ComponetModel.Composition.dll

      Browse to the folder that contains the EPM plug-in dlls.

  4. Create an empty class.
  5. Implement the interface IEpmRibbonExtensibility.
    • Add this using:

      using FPMXLClient.RibbonUtilies;

      using System.ComponentModel.Composition;

    • Add [Export(typeof(IEpmRibbonExtensibility))] just above the definition of the class, as follows: 
       [ Export ( typeof ( IEpmRibbonExtensibility ))]
  public class MemberRecognitionCustomButton : IEpmRibbonExtensibility  
    {
    • Implements all the methods that are defined in the interface IEpmRibbonExtensibility.

      For more information about the methods, see the "Methods" section of the current documentation.

  6. Build your project.
    The .dll is generated. The dll is named after the project and therefore ends with "RibbonExtension.dll". The dll must end with "RibbonExtension.dll".
  7. Copy the dll and paste it in the folder that contains all EPM plug-in dlls.
  8. Open Microsoft Office Excel or PowerPoint.
    Your extension is taken into account.