Skip to Content
0
Former Member
Oct 20, 2008 at 09:23 PM

Bex Query with VB code

12 Views

Hi,

Im trying to create a macro to find and replace cell values depending on certain conditions, I have being following this Blog (Link: [https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3766] [original link is broken] [original link is broken] [original link is broken];) I get to the part where it describes the SAPBEXonRefresh subroutine, when I go to my editor I dont see the SAPBEX module, but I see the xBEXapi which contains the SAPBEXrefresh routine, i tried adding simple msgbox codes but it never gets executed.

What Im doing wrong? Can someone give me some guidance on how to start my macro?

Im using Excel 2003 and BW 2004s

Thanks a lot for your time.