Analyzer - Visual Basic Error

[Former Member]

Hello,

A user can not open the analyzer at his computer as he used to, because after enabling macros, when he clicks on "open query" it appears a visual basic error message. Even using RRMX it does not work and the message says that it can not find c:\program files\....sapbex.xla. But if we go this path we find the file and if we click straight in the file it does not work also. The security for macros is medium or low. Could you please tell what can be the problem.

Regards,

Adriana

[Former Member · Accepted solution]

Hi,

I recalled seeing this problem before. What I did was simply to remap the add-in of Bex analyzer again and this would go away. You just have to make sure that the sapbex.xla file is contained in C:\Program Files\SAP\FrontEnd\Bw\ folder and redirect the add-in to that. Please note that the file path I had specified might be different for the various version of the SAPGui frontend.

In addition, please make sure that you work on a single fresh copy of excel without any files being opened or BW queries ran.

Hope this helps.

Cheers,

Gimmo

[Former Member · Accepted solution]

Gimmo wrote ... note that the file path might be different for the various version of the SAPGui frontend

You can find the file path your version expects by looking in the registry (run regedit.exe) under HKEY_CLASSES_R00T\SAP.BusinessExplorer.Analyzer\path

Hope this helps.

- Pete