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