How trigger a macro with EPM Standard Refresh Button

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Varsha,

I can't use custom button ( requirement !!) to trigger macro only  standard refresh button to be used only. After_refresh  dosn't get triggered.

Thanks

Suvendu

[Former Member · Accepted solution]

Hi Varsha,

It worked . Thanks.