VBA Macros not working with new Add-In 2.3

[Former Member]

Hello All,

We are testing new Add-In 2.3 to embed both Analysis for Office and EPM, however the Input forms that contain some VBA developments on it, stopped working properly.

It seems to me that Reference FPMXLClient stopped working on this version? Does any of you have been through this?

Please, check the screenshots attached.

Thank you in advance,

Cristina

[Former Member]

Hi Cristina,

The EPM API is still available according to the user guide, can you check is the EPM part is installed correctly?

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

There are 3 components in it now, AFO, EPM and BPC.

Andy

[Former Member]

Hi Andy, yes, they are installed correctly.

[Former Member]

Hi Cristina,

I've installed AFO 2.3 and it works as before.

also make sure API is enabled in your VBA.

in developer tab, click on VB button, then select Tools -> References -> Select the FPMXLClient reference

Andy

[former_member186338]

I don't have 3.3 installed but from help it looks like they change object reference...

Dim cofCom As Object

Set cofCom = Application.COMAddIns("SapExcelAddIn").Object

Dim api As Object

Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient")

[former_member571328]

Hi Vadim,

this used to work in our macros before EPM 2.3.:

Dim api As Object
Set api = Application.COMAddIns("FPMXLClient.Connect").Object

api...

Now both of these work:

Dim api As New EPMAddInAutomation
api...

and yours:

Dim cofCom As Object
Set cofCom = Application.COMAddIns("SapExcelAddIn").Object

Dim api As Object
Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient")
api...

Do you know if there is a possible way to keep our former syntax up?

Martin

[former_member186338]

"Do you know if there is a possible way to keep our former syntax up?" - I think no way!

I always use: Dim api As New EPMAddInAutomation