SAP Knowledge Base Article - Public

2436336 - Custom code not working after conversion of BEx workbook

Symptom

After converting a BEx workbook to Analysis Office workbook, the custom VBA code and formulas are not working anymore.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Convert a BEx workbook to Analysis Office workbook according to chapter "To convert a BEx workbook" in User Guide of AO;
  2. Confirm that the custom VBA code which was working in BEx Analyzer is available but not working in Analysis Office workbook;

Cause

Custom code is ignored during the conversion and is not converted. 

Resolution

The custom code needs to be revisited and checked if corresponding APIs are available in Analysis Office.

See Also

1882906 - AO: Converting BexGetData and BexGetCellData formulas

1928881 - Hint for converting BEx Analyzer 3.5 -> Analysis Office

User Guide of AO (chapter "To convert a BEx workbook")

Keywords

analyzer, formula, workbook conversion, customer-specific, vba, formulas, code, coding, api, convert, not available , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions