Open a BEx 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:

Application.Run "BExAnalyzer.xla!runWorkbook", "7JKJM2XEH70HCSWDHEFB21RM5"

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

Application.Run "sapbex.xla!SAPBEXreadWorkbook", "7JKJM2XEH70HCSWDHEFB21RM5"

Write a comment

Comments: 0