Missing FPMXLClient Error while running reports with vba

[Former Member]

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

[Marc_Kuipers]

Hi Bobby,

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

Thanks

Marc

[Former Member]

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

[former_member186338]

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?

[former_member186338]

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

[Former Member]

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

[former_member186338]

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