Question:
Hi all,
I read in the other Posting about the idea to include a macro:
Look SapBex - Refresh
Application.ScreenUpdating = False
Range("A:ZZ").Select
Range("A:ZZ").Replace What:="#", Replacement:=" ", _
SearchOrder:=xlByColumns, MatchCase:=True
Range("A1:A1").Select
Application.ScreenUpdating = True
but how can I acess the SapBex-Refresh?
Iīm asked for a password when I go to sapbex.xla in the VBA-Editor?
thanx
Rello
Answer:
There is a special Macro, void by default, created by BW, named
SAPBEXOnRefresh, attached to the Excel Workbook. No need of password.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
???
and how to acess it???
I coulnīt find anything.
when i open the vba-editor i see:
- SAPBEX(sabbex.xla)
- VBAProject (xSAPtempxxx.xls)
Answer:
Did you try the VBAProject (XSAPxxxx.xls) ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
ok, now it works.
problem was, that the SAPBEX-Module was not there.
so i created this module an included the function
SAPBEXonRefresh(queryID as string, resultarea as Range)
Answer:
Do you mean to say, we have to create Module for SAPBEX(sabbex.xla)
I tried to do it, the system is not allowing me to created.
Kindly explain
Answer:
i send you VBA Code man, but not understand you problem.
check you BEX plugin, i working in BW 2.0B to 3.0B and all time is there that function.
i use all time, and much much VBA codes.
you can try too, fill caracterict when is empty in User-Exits.
then not get # Value.
or too can user Fomule inside Query Design, IF condition or some similar function what asign values for empty values.
sorry my engish.