cancel
Showing results for 
Search instead for 
Did you mean: 

Buttons with VBA code don't work anymore

nancy_borremans
Explorer
0 Kudos

after i installed EPMclient 27 patch 1, i am unable to use buttons with VBA code (as SaveAndRefreshWorksheet, ...)

Before installing new EPMclient everything worked.

in References FPMXClient is checked.

nancy_borremans
Explorer
0 Kudos

installation EPMclient 27 patch 1 on a window 8.1 with office 2010

former_member186338
Active Contributor
0 Kudos

Because Nancy is not interested in the answer any more (look on the date) 🙂

"If FPMXClient_OlapUtilities reference is useless, then what is the problem ?

I have the same problem since I upgraded my EPM to EPM27 and can't find the problem.." - not an issue description!

You have to provide code sample, screenshot of you References and Error screenshot.

P.S. Please delete duplicated answer.

Accepted Solutions (0)

Answers (4)

Answers (4)

karan_kothari2
Participant
0 Kudos

Hi Nancy,

Also check following on your system:

Thnaks,

Karan

former_member186338
Active Contributor
0 Kudos

What for? Never used this!

nancy_borremans
Explorer
0 Kudos

in previous EPMclients i didn't need this.

normally it has to work after installing EPMClient.

former_member186338
Active Contributor
0 Kudos

Yes, FPMXClient_OlapUtilities reference is absolutely useless!

patrice_chartier
Explorer
0 Kudos

If FPMXClient_OlapUtilities reference is useless, then what is the problem ?

I have the same problem since I upgraded my EPM to EPM27 and can't find the problem..

former_member186338
Active Contributor
0 Kudos

Please ask a new question and describe your case in details!

nancy_borremans
Explorer
0 Kudos

module 1 :

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

Dim EPMclient As New FPMXLClient.EPMAddInAutomation
Sub Vernieuwen()

EPMclient.ExpandActiveSheet

EPMclient.RefreshActiveSheet

End Sub
Sub Verzenden()

EPMclient.SaveAndRefreshWorksheetData

End Sub
Sub Kopie()

EPMclient.DataManagerRunPackage "Copy", "Data Management", ""

End Sub
Sub GEP_UREN()

EPMclient.DataManagerRunPackage "Geplande uren berekening", "Financial Process", ""

End Sub
Sub DOORSTUREN_VTE()

EPMclient.DataManagerRunPackage "Doorsturen VTE", "Financial Process", ""

End Sub

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

on excel screen i push button "kopie" (but also with other buttons i have the problem) and get message : error

Error 438 object doesn’t support this property or method

former_member186338
Active Contributor
0 Kudos

Can you show screenshot of your DM packages?

former_member186338
Active Contributor
0 Kudos

Just tested the same - everything working correctly:

VBA:

Dim epm As New FPMXLClient.EPMAddInAutomation
Public Sub test()
epm.DataManagerRunPackage "COPY", "Data Management", ""
End Sub

No issues!

nancy_borremans
Explorer
0 Kudos

I can make it work too. i have to uncheck FPMXLclient, save it, then again check FPMXLclient and save it, and after these actions the buttons work.

my question is why my excisting code worked (before installing new EPMclient) and after installing new EPMclient didn't work anymore.

it looks like by installing EPMClient the link too FPMXLclient is gone but the reference is not updated (still checked)

when i make a new button on a the excisting sheet and i write in same module new VBA code, then that button works, and the others buttons work now too !!!?

i don't want to refresh every reference too FPMXLclient on every excisting template. i installed in the past a few EPMclients and never had problems with my templates.

former_member186338
Active Contributor
0 Kudos

Just checked some old files with FPMXLclient reference - no issues, working fine. Files were created using EPM SP24..

jrg_finster3
Active Participant

Hi Nancy,

unfortunately SAP changed the path where the API libraries are saved. We have the same Problem with AO2.x and we will have to change 200+ Reports.

The error occurs only when using the VBA Reference. If you create The Object by using

Set client = Application.COMAddIns("FPMXLClient.Connect").Object

you dont get an error.

See Note 1931195 for further Details.

Regards

Jörg

former_member186338
Active Contributor
0 Kudos

AO 2.X is a different story. With standalone EPM client - no issues.

I also have confirmation that AO 2.3 is fine (issues with AO 2.2)

jrg_finster3
Active Participant

Now I remember why I stopped posting in this Forum.

Thanks!

nancy_borremans
Explorer
0 Kudos

thanks Jorg,

it works well now

nancy_borremans
Explorer
0 Kudos

error.png : is error message i get when pushing button "Kopie" => english error message =

Error 438 object doesn’t support this property or method

print screen of VBA code and references : references-and-vba-code.png
nancy_borremans
Explorer
0 Kudos

this works on a epmclient SP24

former_member186338
Active Contributor
0 Kudos

Please code text, not a screenshot! Some info is invisible on screenshot!

Then - what procedure generate this error?

former_member186338
Active Contributor
0 Kudos

Please provide a test case with you code! Without code it's a waste of time.

In my system with the same SP27 everything is working correctly.