Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Workbook Refresh issue

Hi All,

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)

MsgBox lData_Provider

End Sub

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

Not what you were looking for? View more on this topic or Ask a question