Differing EPM VBA behaviour for Analysis for Office - EPM Plugin

[Former Member]

Hi all,

We are having a problem executing simple VBA functions when upgrading the Analysis for Office install, including EPM Add-in.

The version we have moved to is 2.3.2, released November 2016.

The problem is that simple code such as that below does not run, even basics such as refreshing.

Below are examples with commentary as to their behavior, varying between "Object reference not set to instance of an object" for code that works OK on version 2.3.0, but not 2.3.1.

Other code format provided in latest AfO EPM Add-in documentation instructs to use code: "Set api = Application.COMAddIns("FPMXLClient.Connect").Object", which does not appear to work.

Any sharing of experience would be appreciated,

NC

EPM version is 2.3.2.60825

[Former Member · Accepted solution]

Hi Nick,

Instaed of normal EPM Addin guide refer to Analysis for Office EPM Plug in guide for macro help..... pg 448

http://help.sap.com/businessobject/product_guides/AMS23/en/23SP2_epmplugin_user_en.pdf

http://help.sap.com/boaa

Regards,

JP