Skip to Content
avatar image
Former Member

Missing FPMXLClient Error while running reports with vba

Hello, Recently we have upgrade to office 365 and AO2.5 both 32 bit version and noticed that some of the EPM reports with vba are giving errors

Error like Compile error : Can't find project or library.

The same report will work fine on Office 2013 with out any issues

In the excel developer> VB editor under tools > references we noticed that it indicates "Missing :FPMXLCLient". We tried to browse and point to FPMXLClient.dll in the installation directory but that gives an error.

We tried to unregister and reregister using regsvr32 command but the command won't accept this dll file.

Is there a way to fix this reference issue.

Experts greatly appreciate your help and suggestions.

We have a lot of reports and we cannot change them.

Thanks

Bobby

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 22, 2017 at 07:43 AM

    If you open Excel with empty workbook and go to VBA references what do you have? Please provide screenshot. Check the path for FPMXLClient.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2017 at 04:31 PM

    Thank you for the response Vadim. Please the additional information . I am surprised that no one encountered this error before.

    When we open excel (blank Page) and login to EPM the reference to FPMXLCLient is not selected (Checked) (See screenshot 1). However if you scroll down the list of available references you can see FPMXLClient and it is pointing to

    C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\FPMXLClient.dll

    -----------------------------------

    After a EPM report is loaded the reference now says missing as it is pointing to

    C:\Program Files\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin instead of

    C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin (see screen shot below)

    If you scroll down you can see another FPMXLclient reference which is pointing to "C:\Program Files (x86)\SAP......."

    If I select browse and point to C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\FPMXLClient then i get error

    Looks like there VB is expecting a file in C:\Program Files\ location but the FPMXLCLient is located in

    C:\Program Files(x86)\ location and it doesn't like it.

    Appreciate you time and effort on this,

    Thanks

    Bobby

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 10:03 PM

    Hi Bobby,

    Have you checked this: https://service.sap.com/sap/support/notes/1931195

    Thanks

    Marc

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2017 at 05:10 PM

    Please check what do you have here:

    C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\FPMXLClient.dll

    Screenshot of Explorer window? With the path: C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\

    Next:

    "After a EPM report is loaded the reference now says missing as it is pointing to" - you old report has incorrect reference, please perform all tests with new file and create a new VBA macro with reference to

    C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\FPMXLClient.dll

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2017 at 05:16 PM

    Thanks for the response Vadim,

    File FPMXLClient exists in

    "C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\". However I cannot load it into the reference. From the VBA reference library when i browse to this location and add this dll we recieve error message. "Can't add a reference to the specified file." even though the file exists in that location.

    I think the issue is due to the fact that when AO 2.5 is installing the software it is defaulting the installation dir to C:\Program Files (x86)\SAP BusinessObjects\Office AddIn\Plugins\EPMAddin\ because it detects that the computer is a windows 10 64 bit but the office is 32 bit. However the libraries in that folder cannot be loaded.

    That means i cannot create a new macro referring to that library. Moreover, this means i need to change all the reports which is the last possible option for us.

    Thanks

    Bobby

    Add comment
    10|10000 characters needed characters exceeded

    • There is no file just FPMXLClient

      What is the file extension?

      Windows 10 64 bit version has no relation to the issue (I also use Windows 10 64 bit)

      Once again:

      Open Excel with a new file.

      In VBA add reference to FPMXLClient

      Add some simple EPM code.

      Test it.

      Is it working?