cancel
Showing results for 
Search instead for 
Did you mean: 

How trigger a macro with EPM Standard Refresh Button

Former Member
0 Kudos
272

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Varsha,

It worked . Thanks.

Answers (0)