Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 01 at 07:42 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded