Skip to Content
0
Former Member
Feb 21, 2007 at 12:17 PM

Macro in local workbooks

17 Views

Hi,

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)

-


Macro code

EndSub

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.

Thanks.