EPM giving automation error after upgrade

[aditya_ponnala]

Hello

We went live with Upgrade (From BW 7.4 to 7.5 and EPM to AO Version 2.5.1) and we are having VB error: Automation Error Invalid Pointer wherever we are using FPXML commands in VB as shown below

Dim Save as New FPXMLClient.EPMAddInAutomation

Save.SetSheetOption "",1,False

The Odd part is, it is giving this error only for one user of all and this one user is the one who used the PC in the past with earlier version of EPM. Naturally we felt that some cache is the problem and deleted EPM Cache in below folders

1.  Delete the metadata cache for the EPM Add-in to have it regenerate this information upon the next logon.

2. Delete the EPMXLClientPreference.XML

3.  Delete the Connections.xml file associated to the user account.

And still we get this VB error only for one user.

We reviewed notes: 1767781 and 1931195 and understand SAP recommendation here. However please note that existing layouts are working fine for all users except for one who used the PC in the past.

OS: 64 bit Windows 7 or 10

Office 2013

EPM from AO 2.5.201

Anyone faced the same issue and resolved it?

[aditya_ponnala]

Just so others know, after upgrade to AO, FPXML is located in Program files (86) folder on 64 bit and Program files on 32 bit OS.

[aditya_ponnala]

Yes, we tried that option and that works. But that means lot of changes and in all our lower clients in testing the existing code works. We have been using EPM version 25 from past two years and we had not problem.

Even now after upgrade only a selected few are getting this VB error. And even for these selected few, it is an issue if they login with the same computer as in the past.

Changing VB code on all layouts is a huge task and am sure we are bound to face more challenges in upgrading the VB code that calls package from Excel.

Thanks!

[former_member186338]

Unfortunately there is no other solution. The library location was changed.

[former_member186338]

Use late binding instead of References selection: read my answer here

https://answers.sap.com/questions/437650/vba-code-to-refresh-active-sheet.html