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"

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0