Skip to Content
avatar image
Former Member

EPM VBA Broken API Reference File?

I'm using EPM 10 Excel-Addin and want to use the EPM API in VBA code. I have FPMXLCLIENT reference enabled and I can look up the object browser. However, any time I try to build code that refers to any class (EPMAddInAutomation class for example), I get invalid pointer error: '2147467261 (80004003)'. I'm thinking my API reference file might be broken because the following simple code my department at work created for auto-login doesn't work on my machine but does work for my colleagues:

Public Sub finance_login()
    Dim emp As New FPMXLClient.EPMAddInAutomation
    emp.Connect "_EPM_BPCNW10_[http://...", "user", "password"
End Sub

Can anyone assist with a remedy?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 09, 2017 at 08:47 PM

    What EPM SP is used?

    EPM uninstall/reinstall?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 12, 2017 at 01:19 PM

    Looks like you are talking not about standalone EPM client, but about AO 2.3

    As far as I remember AO 2.4 has no issues with VBA referencing. Upgrade to it or use standalone EPM client SP23-28

    By the way, do you use standard or embedded BPC?

    Add comment
    10|10000 characters needed characters exceeded