Skip to Content
avatar image
Former Member

Differing EPM VBA behaviour for Analysis for Office - EPM Plugin

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


error1.png (21.6 kB)
capture.png (62.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 22, 2016 at 07:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 06:31 AM

    Object declaration is different in AO compared to EPM. Please search.

    Add comment
    10|10000 characters needed characters exceeded