Skip to Content
0
May 11, 2010 at 09:14 AM

VB macros not running at query refresh

26 Views

Hi,

We have written functions in module in VB macros and we are calling them at the event:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

If queryID = "SAPBEXq0006" Then

Function 1

ElseIf queryID = "SAPBEXq0007" Then

Function 2

ElseIf queryID = "SAPBEXq0004" Then

Function 3

End If

End Sub

These macros are executing perfectly fine at the concerned query refresh (Patch level 7, patch level 15)

However, these macros are not getting executed when the workbook is run at SAP patch level 17. When we are refreshing the workbook for the first time, the macros will not get executed, however when we again refresh the workbook, the macros will get executed and populate the correct results.

Please let me know what could be the possible reason and what shall be the solution.

Thanks,

Anil