2151942 - Unable to open BEx Analyzer and execute SAP .XLA files

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Even after implemented the instructions of SAP Note 1962327 - No response from the Toolbars in BEx Analyzer, you are experiencing one of the following message errors while openning BEx Analyzer:

• Cannot run the macro 'xxxxxxx'. The macro may not be available in this workbooks or all macros may be disables.
• Microsoft Visual Basic for Applications: Complie error in hidden module: cBEXcommon.
• Microsoft Visual Basic for Applications: Complie error in hidden module: main.
• Microsoft Visual Basic for Applications: The code in this project must be updated for use on 64-bit systems.
• Microsoft Visual Basic: Run-time error '-21470224894 (80070002)'
• Microsoft Visual Basic Method 'GetFileVersion' of object 'IFileSystem3' failed
• Run Time Error 91 - Object variable or with block variable not set

 

   

Read more...

BEx Analyzer 7.0

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Compile error in hidden module, The code in this project must be updated for use on 64-bit systems, The macro may not be available, BEx, Analyzer, Microsoft Visual Basic, Compile error in hidden module main, xBEXcommon, Compile error:,The code in this project must be updated fot use on 64-bit systems, ptrSafe attribute, Run-time error -2147024894, 80070002, 2147024894, Method GetFileVersion of object IFileSystem3 failed , KBA , BW-BEX-ET-WB-7X , 7.x Analyzer Frontend , BW-BEX-ET-BC-PREC , Precalculation Server / Export of Workbooks , Problem