In 7.0 and 3.5 you can open workbooks via VBA. This is useful if you want to automate reporting. The command for BEx Analyzer is:
1 |
Application.Run "BExAnalyzer.xla!runWorkbook", "7JKJM2XEH70HCSWDHEFB21RM5" |
7JKJM2XEH70HCSWDHEFB21RM5 is the id of the workbook. In 3.5 the command is:
1 |
Application.Run "sapbex.xla!SAPBEXreadWorkbook", "7JKJM2XEH70HCSWDHEFB21RM5" |
These posts might also be interesting:
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office?
You want to know how functions in SAP Analysis Office works?
Then you have to take a look into Analysis Office - The Comprehensive Guide.
Write a comment