on 11-29-2016 10:40 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
Now I remember why I stopped posting in this Forum.
Thanks!
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.pngYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.