Dear All,
I have a workbook with more than 10 queries. I want to refresh particular queries as refreshing all gives us a very complex variable screen.
I have seen that SAPBEXrefresh function currently isnt supporting it in Bex 7.0.
Does anyone have any idea how can i perform it?
BR
Alkan
Public Function SAPBEXrefresh(allQueries As Boolean, Optional atCell As Range) As Integer
'In the 7.0 Analyzer, ALL the items in the workbook can be refreshed, but refreshing
'a query individually is not supported
On Error Resume Next
extErrorBegin ("3.x API SAPBEXRefresh called")
If allQueries = True Then
Common.MenuRefresh
SAPBEXrefresh = 0
Else
SAPBEXrefresh = 700
p_extErrorText = "With 7.0, this API is partly supported to refresh ALL items in the workbook, NOT an individual Query"
End If
extErrorEnd
End Function
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.