VBA in BEx: macro call on saving a WB

[Former Member]

Hi experts,

I want to know if it's possible to execute macros after clicking on standard button on BEx toolbar "Save an existing workbook"?

For example, the similar macro call for button "Refresh" we implemented as follows:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

     Call plan_SAPBEXonRefresh(queryID, resultArea)

End Sub

But how can I do this for another button?

Hope for your help!

Thanks in advance,

     Mariya.

[Former Member · Accepted solution]

Hi Mariya,

We have a function 'SAPBEXsaveWorkbook' for maintaining a customization on buttons etc and its not meant for creating action item.

This particular SAPBEXonRefresh provided for defining action items .

We need to know the standard code for accessing that standard save/open buttons which is not in scope of the users.

[Former Member · Accepted solution]

It's a pity!(

Thanks.

[Former Member · Accepted solution]

May be you know whether it's possible to add new button to BEx toolbar?

[Former Member · Accepted solution]

Thats the feature sap need to give and as of now we do not have this too.

New buttons can be added for save/refresh/etc purposes in our workbooks.

Its everything on developers hand, if we have code from sap then we can do.