I have a workbook stored locally and not on the BW server. There is a macro present in the workbook. I need to run this macro automatically when the
workbook is run. I have tried with the code
Sub SAPBEXonrefresh(queryID as string, resultarea as range)
However, whenever the new workbook is newly open, the sheet name changes (xSAPtemp137.xls or xSAPtemp139.xls etc) and this code fails.
Can anyone please suggest a solution for this.