Open a BEx Analyzer workbook via VBA

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:

7JKJM2XEH70HCSWDHEFB21RM5 is the id of the workbook. In 3.5 the command is:

These posts might also be interesting:

• Analysis Office SAPOpenWorkbook
• Analysis Office Logoff
• How to convert a text field into a date field with VBA
• Load VBA code from a text file

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.