Skip to Content
0

Buttons with VBA code don't work anymore

Nov 29, 2016 at 10:40 AM

199

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Nov 29, 2016 at 10:48 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nancy Borremans Nov 29, 2016 at 10:56 AM
0

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

error.png (122.7 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

this works on a epmclient SP24

0

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

Then - what procedure generate this error?

0
Nancy Borremans Nov 29, 2016 at 11:11 AM
0

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

Show 8 Share
10 |10000 characters needed characters left characters exceeded

Can you show screenshot of your DM packages?

0

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!

vba.png (35.1 kB)
ares.png (486.6 kB)
0

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.

0

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

0

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

1

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)

0

Now I remember why I stopped posting in this Forum.

Thanks!

1

thanks Jorg,

it works well now

0
karan kothari Nov 29, 2016 at 11:16 AM
0

Hi Nancy,

Also check following on your system:

Thnaks,

Karan


1.jpg (66.2 kB)
Show 5 Share
10 |10000 characters needed characters left characters exceeded

What for? Never used this!

0

in previous EPMclients i didn't need this.

normally it has to work after installing EPMClient.

0

Yes, FPMXClient_OlapUtilities reference is absolutely useless!

0

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..

0

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

0