Skip to Content

VB Code changes with new AO Version

We are in the process of migrating from EPM to AO version.

This below code which used to work in EPM is not working in AO version: Plug in 2.5 SP02

Dim EPM As New FPMXLClient.EPMAddInAutomation
Dim filename As String

EPM.RefreshActiveSheet

Upon contacting SAP they recommended note;2259931 and relevant notes and this notes says to re-write code as.

Sub MyMethod()

Dim cofCom As Object

Dim epmCom As Object

Dim result As String

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

cofCom.ActivatePlugin("com.sap.epm.FPMXLClient")

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

// ->Just call the API on epmCom

End Sub

I gave a small example of my code but there is lot of code like calling package from VB. Did anyone try to switch your code? Can you help port our code to new AO version

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 15, 2017 at 07:26 PM

    OSS note is 2259913

    and Library references are:

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 04:29 PM

    Are you sure: 2259931 - FAQ of Brazil's EC87 and NT003 solutions ???????

    Please show screenshot of your VBA References.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2017 at 02:22 PM

    Path:

    Hover mouse pointer over this line to see full path!

    Add comment
    10|10000 characters needed characters exceeded

    • The location of library was changed not once, but number of times! Please check again that you have file in the path shown in References.

      About the code - use simple code to test! Like:

      Public epm As New FPMXLClient.EPMAddInAutomation
      
      Public Sub Test()
          MsgBox epm.GetDataTopLeftCell(ThisWorkbook.Worksheets("Sheet1"), "000")
      End Sub

      Compare with your code!