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.