can i put macro that execute after the input template is refresh ?

[Former Member]

Hi All,

I created macro to fill certain formula in the cell. The question is, how can i put this macro execute automatic after the input template is refreshed ?

Thanks,

Suprapto

[Former Member · Accepted solution]

Dear All,

I put these line in my module.

Dim EPM As New FPMXLClient.EPMAddInAutomation

Sub AFTER_REFRESH()

< my code >

End Sub

Thanks

[former_member190501]

Hi,

Try as follows ...

Dim EPM As New FPMXLClient.EPMAddInAutomation

Sub REFRESH_DATA()

EPM.RefreshActiveSheet

<Insert your code here..to fill formula in the cell >

End Sub

Hope it helps...

regards,

Raju

[Former Member]

Hi Raju,

Sorry, i change my question. Is it my macro can execute automatically if user click button refresh from BPC ribbon ?

Thanks,

Suprapto

[former_member210696]

Hi Suprapto,

I don't think it's possible to achieve what you are trying to do. As an alternative, create a custom button and assign two macros to it, first refresh and then the one which you have designed. So, in effect, once user clicks on that button, it would first refresh and then call the required macro.

Hope it helps!!