Can we add macro functionality when we click SAVE DATA button in IBP add-in

[rahul_kumar124]

Hi Experts,

I have implemented a Macro within excel & added a macro button also for calculating a cell value.

Is it possible to add this functionality in SAVE DATA button in IBP Excel Add-in.

So, expectation is whenever I click on SAVE DATA button this macro should run automatically and save the results.

[former_member194529 · Accepted solution]

HI Rahul,

I would say that the only feasible actions that can be triggered specifically to hitting the Save Data button are the ones described on below Note about available VBA Hools:

2421657 - Implementation of VBA Hooks

https://launchpad.support.sap.com/#/notes/2421657

Best,

Ivan

[riyazahmed_ca2]

Hi Rahul,

VBA hooks has the features to run a specific instance based on the following call modes.

1) SIMULATE

2) SAVE

3) REFRESH

etc,. You can make use of them with appropriate if-else statements to use these callmodes to execute your VBA statements.

Regards,

Riyaz