Skip to Content
0
Former Member
Dec 06, 2010 at 01:24 AM

how to use API:SAPBEXSetFilterValue in bex7.0

64 Views

hi,guys,

How to automate refresh bex7.0 workbook with VBA code? I found the function SAPBEXSetFilterValue.

The vb code like :

If Run("bexanalyzer.xla! SAPBEXSetFilterValue",YOUR_1_VARIABLE_VALUE,u201Du201D, Sheets("Query_A").Range("B7")) = 0 Then

Else

MsgBox "Function failed"

End If

my bex analyzer support package13.Revision 1705.

thanks a lot.

Edited by: xwu wu on Dec 6, 2010 2:24 AM