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
- Convert a BEx workbook to Analysis Office workbook according to chapter "To convert a BEx workbook" in User Guide of AO;
- 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