SAP Knowledge Base Article - Preview

2259913 - VBA code in EPM Add-in does not work in Analysis for Office 2.7 (or lower) EPM Plug-in

Symptom

The same VBA code that works in the SAP EPM Add-in does not work in SAP Analysis for Microsoft Office (AO /AfO) EPM Plug-in.

The following code is taken from the "help "menu of EPM Add-in:

         Sub test()
               Dim api As Object
              Set api = Application.COMAddIns("FPMXLClient.Connect").Object
              api.ExecutePlanningFunction "PF_1"
        End Sub


Read more...

Environment

  • EPM Add-in for Microsoft Office
  • SAP Analysis for Microsoft Office (AO) 2.7 or lower

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

analysis, office, epm, vba, code, AO, , KBA , no longer works , fpmxlclient , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.