Skip to Content
0

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

Jan 16 at 03:52 PM

95

avatar image
Former Member

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

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

1 Answer

Best Answer
Elise Teixeira
Feb 01 at 07:42 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded