Many colleagues have experienced difficulty attempting to install the EPM add-in on Microsoft Office 2013 due to the following error message: “THE FOLLOWING COMPONENTS ARE REQUIRED: – MICROSOFT VISUAL BASIC FOR APPLICATION 2013 OR LATER”. Thus we need to locate an installer for Visual Basic for Application 2013 or later. (Important: I spent a long time attempting to locate a VBA 2015 Module that came from a “trusted and unbiased” website such as microsoft.com. The only website that I was able to locate that will provide all users this piece of VBA software comes from the Autocad Support website. I am not advertising for Autocad, but simply providing a link to download the file needed to successfully install the BPC client on Office 2013. I will continue to search for a trusted and unbiased website. When one turns up, I will update this accordingly.)

Please see below for the steps to successfully install the BPC client on Microsoft Office 2013. I have successfully tested this installation on both the CD Installer, as well as the Microsoft preferred installation method of Office 2013, the Web Installer.


  1. It is imperative that you identify what .NET FRAMEWORK your local machine is using. To be absolutely sure, determine by looking in your Registry Editor using this method http://msdn.microsoft.com/en-us/library/hh925568(v=vs.110).aspx You’ll want to be careful while navigating around the registry editor and not change anything. We need to know this for future steps.
  2. You must ascertain that you meet all requirements needed system wide, as well as on your local machine, in order to be able to run the BPC client.
  3. Verify whether you have 32-bit or 64-bit Office 2013 installed. This is a crucial step as we need this information for numerous other steps. You can do this by opening up Excel and  clicking on FILE > ACCOUNT > ABOUT EXCEL. You can easily find what version you have on the first line of the “About Microsoft Excel” window.                             /wp-content/uploads/2014/08/scn1_439327.png
  4. Download the correct version of of the EPM Add-in installer. Again, download your respective version, either 32-bit or 64-bit. Navigate to https://support.sap.com/software/patches.html From here select “B” to filter installation and upgrades by software containing “B” for BPC.
  5. Select SAP BPC FOR SAP NETWEAVER. /wp-content/uploads/2014/08/scn2_439340.png
  6. The following window will ask you if you have BPC 7.5 or BPC 10 installed. Select the proper version your system is running.
  7. You should be at the SAP PLANNING AND CONSOLIDATION X.X, VERSION FOR SAP NETWEAVER info page. Click on SUPPORT PACKAGES AND PATCHES.                                                 /wp-content/uploads/2014/08/scn3_439347.png
  8. Select ENTRY BY COMPONENT.                                                 /wp-content/uploads/2014/08/scn4_439352.png
  9. This is where you need to know what version of the .NET Framework you are using. Make the appropriate selection as dictated by the environment on your local machine.                                                                                                      /wp-content/uploads/2014/08/scn5_439356.png
  10. Expand this tree until you get to WIN32.                                                                                                                             /wp-content/uploads/2014/08/scn6_439358.png
  11. Click on WIN32 to open the DOWNLOADS window from which you will select the most recent client which currently is SP17. /wp-content/uploads/2014/08/scn7_439359.png
  12. Do not install the EPM Add-in yet as you will receive the usual error message of: “THE FOLLOWING COMPONENTS ARE REQUIRED: – MICROSOFT VISUAL BASIC FOR APPLICATION 2013 OR LATER”.
  13. In order to successfully install the EPM add-in we need to install VBA. I used the 2015 AutoCad VBA module available from the AutoCad site.
  14. Navigate to http://knowledge.autodesk.com/support/autocad/downloads/caas/downloads/content/download-the-microsoft-visual-basic-for-applications-module-vba.html
  15. Select the AutoCad 2015 VBA Module dictated by the needs of your system, either 32-Bit or 64-Bit.
  16. After downloading, extract to a location of your choice. YOU MUST TAKE NOTE OF THIS LOCATION.
  17. If you used the AutoCad VBA download and don’t have AutoCad / AutoDesk installed, you will receive an error message. You will still be able to use the VBA download. Proceed to the next step.
  18. Locate the extraction folder again and open the 3rdParty folder. /wp-content/uploads/2014/08/scn9_439369.png
  19. Open the VBA Folder.                                                         /wp-content/uploads/2014/08/scn10_439370.png
  20. Run the VBA71.msi installer.                        /wp-content/uploads/2014/08/scn11_439372.png
  21. After double clicking you may or may not get confirmation that the VBA Module installed.
  22. Finally, run the EPM Add-in installation file from Step 4. If the EPM Add-in installs without error, this will also confirm that the VBA module installed.
To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Robert Jennings

    Cesar

     

    Thanks for this post – it solved the issue I was having.  We are using Office 365 ProPlus and could not get past the VBA requirement.  I was told that VBA is installed with Office 365 ProPlus, but seems this is not the case.

     

    Interesting as well – after installing VBA from the Autodesk media, it does not show in Add-Remove Programs.

     

    Thanks for the sleuthing !

     

    Regards

    Rob

    (1) 
  2. Chris Sorensen

    Cesar,

     

    Have you tried this with the EPM add-in for the Microsoft Edition of BPC? This post under the “SAP Planning and Consolidation, version for the Microsoft platform” but it is making references to Netweaver.

     

    Cheers,

    (0) 
  3. Arthur B

    Hi,

    A client sent me an excel file (financial model) using  BPC. Here are some instructions that were provided with the file:  “Select desired Business Unit from Current View Action Pane. File will Expand and applicable tabs will populate with BPC data. Once file is populated with BPC data follow steps below: Use Park N Go and set file to “Set to Offline (no connectivity)”. Save file to your local PC/ laptop.   You must select “Excel Macro-Enabled Template” as file type. Open file locally outside BPC”.

    Attached is a screenshot of what I can see without the BPC add-in.

     

    I was going to install the EPM add-in (following the above instructions) but I could not download the file because I don’t have a log in to connect to the support SAP website (I am not an SAP client).

     

    Is there a way for me to get this add-in?

     

    FYI – My setup is:

    Excel 2013 (32 bit)

    .Net Framework 4.5.2

     

     

    Thank you very much for your help

     

    Capture2.JPG

    (0) 
    1. Cesar Quintero Post author

      Sorry Arthur, I’m pretty sure you need to have a proper account to download the tool. Ask your client to provide access to the tool.

      (0) 
  4. Bjorn Van Damme

    Same when you are running Office 2016. Strange, I understand that Cesar is pointing to Autocad as it has the Vba installer file, but SAP should really look into this. Installing a file from AutoCad to get EPM up and running…

    (0) 
  5. Pratap Sone

    Hi Cesar,

     

    Reports with custom VBA Ribbon fails with below error after installing EPM add-in for office 2013. Using below patch:

    EPMEXCLCLNT25_0-10011004.ZIP

    SP25 for SBOP EPM EXCEL CLIENT 10.0


    Error looks like below. Can you help?

     

    VBA Error.jpg


    Regards,

    Pratap

    (0) 

Leave a Reply