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