Skip to Content
0

Range reference to SBD Report broken after refreshing report via VBA macro

Sep 05, 2017 at 08:20 AM

32

avatar image
Former Member

Hi,

I have created a macro to perform a report refresh automatically. But I have noticed that after the macro refreshes the SBD reports, the range reference for the SAP_ByDesign_R00xx named range gets broken. For example, when the range is something like: ='99. PM11A'!$A$4:$DS$10, then after I run the macro, the range reference shows something like ='99. PM11A'!$DS$1. I notice that when I then subsequently refresh the report manually through the Add-in ribbon, the range reference for that report is fixed again. But I actually don't want a manual step in the process.

The code in the macro that I use is the following with R0010 referring to one of my SBD reports in the Excel

Dim addinWrapper As AnalyticsAddin

Set addinWrapper = New AnalyticsAddin

Dim report As Object

Set report = addinWrapper.getReport(Range("SAP_ByDesign_R0010"))

report.Refresh False

I am wondering how I can fix the VBA code such that the range reference to the report remains intact.

- Mark

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers