Workbook Refresh issue
I have a problem with workbook refresh. Here is the issue:
I have inserted 3 queries into a workbook. As per requirement, I need a certain column values to calculate and populate a set of coulmns. I wrote a VB Macro. The issue is that the workbook refreshes without the macro,but when I insert the macro, it fails to refresh.
I am not sure if I am inserting the SAPBExOnRefresh code at teh right place. Here is what I am doing:
Open VB Editor
->Right Click on Modules>Insert Module-->Name it as RefreshMacro.
In the Macro, here is the initial code I am writing.
Sub RefreshMacro (ParamArray varname())
Dim lData_Provider As String
lData_Provider = varname(0) ******Do I have to physically pass the Data Provider Name into varname(0)???????
Set lRange = varname(1)
After this my Macro code is inserted.
Private Sub Workbook_Open()
Dim buss_seg As String
Dim mon_hnd As String........
I have in the workbook settings, checked the automatic refresh on Open and in the exits tab, changed the name for the Macro to RefreshMacro(the macro name of mine).
I have tried all the options but still the workbook does not refresh.
Any steps on where to insert the code and any other changes in the declaration that I need to make? Help is greatly appreciated and rewarded.
PS: I am on BI SP12 and GUI 710 Patch 8.
Any Help or solutions?????
Edited by: Sree Rama Tata on Sep 15, 2008 5:38 PM