I have a toolbar with a "RefreshNow" button that I want to preempt so I can
do some extra steps. I have ID'd the toolbar and button object code as :

commandbars("Business Explorer").Controls("RefreshNow")

I have tried :

commandbars("Business Explorer").Controls("RefreshNow").OnAction = MsgBox

(for example), but this does not seem to work. I would like the preempt to
work on all tabs of this workbook.

For a procedure name, I tried "Sub RefreshNowButton_click()".

Any Ideas would be greatly appreciated.

Is this related to the SAP add-in for Excel VBA? I don't have any
experience with SAP, so can't really advise much, except that I found
the following web page sort of related to this:
"Integration with Visual Basic for Applications"
http://help.sap.com/saphelp_bw21c/he...fe/content.htm

You might have to call SAP technical support, or see if you can get a
more detailed technical document somewhere that might describe how to do
this. It appears from this page that you can do things AFTER the Refresh
has occurred. If they don't have a hook of some sort at the front of
their "Refresh Now" routine, then this might not be possible.

Is it possible to add a workbook of your own with its own toolbar that
would have a button to do the stuff you want to do before clicking on
the "Refresh Now" button?

It might be possible to display the Customize dialog box, then select
the "Refresh Now" button, and Assign Macro to a macro of yours, which
does your stuff, then calls their routine in their code, but this could
get complicated or might not even be allowed (imagine the security
breach where a virus overtakes your machine and redefines all of your
toolbar buttons!).
--
Regards,
Bill Renaud

thanks. Unfortunately the web site shows a macro that get created when you
open the workbook but I can't seem to find it. I eveb looked in the very
hidden worksheet.

Anyway, I was able to do a workaround.

Thanks for the help though.

PS I think this is an older version of BEx, note the BW21c in the site id.
We are on BW3.5 and moving to 2004S.

"Bill Renaud" wrote:

Is this related to the SAP add-in for Excel VBA? I don't have any
experience with SAP, so can't really advise much, except that I found
the following web page sort of related to this:
"Integration with Visual Basic for Applications"
http://help.sap.com/saphelp_bw21c/he...fe/content.htm

You might have to call SAP technical support, or see if you can get a
more detailed technical document somewhere that might describe how to do
this. It appears from this page that you can do things AFTER the Refresh
has occurred. If they don't have a hook of some sort at the front of
their "Refresh Now" routine, then this might not be possible.

Is it possible to add a workbook of your own with its own toolbar that
would have a button to do the stuff you want to do before clicking on
the "Refresh Now" button?

It might be possible to display the Customize dialog box, then select
the "Refresh Now" button, and Assign Macro to a macro of yours, which
does your stuff, then calls their routine in their code, but this could
get complicated or might not even be allowed (imagine the security
breach where a virus overtakes your machine and redefines all of your
toolbar buttons!).
--
Regards,
Bill Renaud