on 10-08-2007 5:33 AM
Hi,
In my query & webtemplate I want to replace the '#' value with blank for a charactrestic.
I have read many posts on this forum, and tried them all, but I am unable to crack.
Following are the steps followed by me
go Tools-Macro-Visual Basic Editor.
Left Side you will see "This Workbook". Double click it.
Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Dim c As Range
For Each c In resultArea.Cells
If c.Value = "#" Then c.Value = ""
Next c
End Sub
I am working on BW 3.5 & Excel 2003
Thanks
Priya
HI ,
I want to tell you one solution to remove '#" in the reporting level.
Go to InfoSource -> click on the field for which you are getting '#' in transfter rule
-> Select Formula -> create Formula as follows.
If (InfoObject = ' ', ' . ',InfoObject)
This means while loading the data from the source system, it will check that if there is any space for that InfoObject, place as Space otherwise place same InfoObject.
Regards
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try out this:
copied from one of the posts
Here are the steps to do the same
1) In excel menu Tools->macro
2) Enter the macro name say SAPBEXonRefresh
3) click 'create', will go to visual basic editor
4) To display '#' as '', paste the following code
Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Dim c As Range
For Each c In resultArea.Cells
If c.Value = "#" Then c.Value = ""
Next c
End Sub
5) Close the editor and click on refresh again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've tried this before in workbooks and it has worked well.
To remove the # value from within a query and replace with a space
Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
'Find the Cells in Result Area and Change them
resultArea.Replace What:="#", Replacement:=" ", LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True
End SubSub SAPBEXonRefresh(queryID As String, resultArea As Range)
'Find the Cells in Result Area and Change them
resultArea.Replace What:="#", Replacement:=" ", LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True
End Sub
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.