Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How trigger a macro with EPM Standard Refresh Button

Hi  Friends,

I have a requirement where I need to trigger a macro with standard refresh button . and is it possible to trigger  ARTER_REFRESH  with standard  refresh button.

Any help will be highly appreciated.

Thanks

Suvendu

Former Member
Former Member replied

Hi Suvendu,

Yes you can trigger a macro with refresh button.

Try the syntax :

Option Explicit

Sub RefreshButton_Click()

Dim api As Object

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

api.Refresh

End Sub

Also, you can trigger the macro After Refresh

Option Explicit

Function AFTER_REFRESH()

//Place you code here//

AFTER_REFRESH = True

End Function

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question