Compile error in hidden module cBEXcommon

[Former Member]

Hi

whenever i try to open up the Bex analyzer from Start-> all Programs -> Business explorer -> Bex Analyzer

it opens up Microsoft excel with error -

Microsoft VB for Applications

Compile error in hidden module cBEXcommon

This error commonly occurs when code is incompatible with verrsion, platform or architecture of this application.

Even after this if i try to click Open query it gives error

Cannot run the macro 'sapbex.xla!repoNewQuery'

i tried copying SAPBEX.XLA from another machine where it works but this still doesnot work..

my machine has windows 7, another machine has windows xp

are there any new patches or addins for windows 7

thanks very much for help

[michael_devine · Accepted solution]

Hello

Can you please follow the steps as below:

1.Control panel > Add or remove programs > uninstall Sapgui

2.Control panel > Add or remove programs > uninstall Sap bex explorer

3.Delete the following folders in the PC

C: \program files/SAP/Frontend

C:\Program Files\SAP\Business Explorer

C:\Program Files\Common Files\SAP Shared

C:\Documents and Settings\All Users\Start Menu\Programs\SAP Front End

C:\Documents and Settings\All Users\Start Menu\Programs\BusinessExplorer

4.Delete the files in the recycle bin and reboot the PC. (this step is important)

5 After the reboot, first install the GUI 710/720 with the latest patch level

6 Install BEx 7.0 and BEx 3.5 with the latest patches for each.

Regards,

Michael