on 10-20-2008 10:23 PM
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.
Hi,
Do you want to find and replace the cells value within sheet or From sheet1 to sheet2?
If you want to replace the cells value within a Sheet use =replace function on a required cell. It works like a refresh.
Thanks,
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.