Skip to Content
0
Former Member
Dec 27, 2007 at 10:49 AM

Refresh individual queries in the workbook (BeX 7.0)

27 Views

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