cancel
Showing results for 
Search instead for 
Did you mean: 

ByDesign Excel Add-in - How to set interval parameters for a report in VBA?

Former Member
0 Kudos

Hi,

I have created a macro in Excel that automatically refreshes SBD reports taking variables from various Excel cells. There is however one variable (Accounting Period/Year) which is an interval period. Since it is not possible to add in the selection pane a reference to a cell containing the correct period values, I am trying to find a solution whereby I can change the report parameter values in the vba itself.

I have tried to find documentation that describes what parameters exist with a report and what values you can give each report parameter, but I cannot find it.

I did find this discussion https://archive.sap.com/discussions/message/16101957#16101957 but the solution provided in this thread doesn't work. If I apply this, the Accounting Period/Year parameter for the report gets just a single value, not the interval.

Anybody have any suggestions?

Mark

Accepted Solutions (1)

Accepted Solutions (1)

former_member240517
Participant
0 Kudos

Hi Mark,

It is possible to change the report parameter values in the VBA itself, however, you need to contact your implementation partner in order to get the object name, classes, methods, then you will be able to reference it via VBA.

I hope it helps you.

Best Regards,

Elise Teixeira.

Answers (0)