on 09-05-2017 9:20 AM
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
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.