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 ONE Support launchpad (Login required).

Search for additional results

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