on 01-16-2018 3:52 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.