EPM VBA Broken API Reference File?

[Former Member]

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?

[former_member186338 · Accepted solution]

What EPM SP is used?

EPM uninstall/reinstall?

[Former Member · Accepted solution]

v2.3 support package 2.

This is the updated version that I had my IT department upgrade me to. The upgrade didn't help my issue. Would I be able to just delete and re-add the VBA reference file instead of doing a complete reinstall?

[Former Member · Accepted solution]

An uninstall/reinstall fixed my problem.

[former_member186338]

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?