cancel
Showing results for 
Search instead for 
Did you mean: 

Analyzer - Visual Basic Error

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Adriana,

I have not heard of this exact problem before. But, if you are getting a Visual Basic Error, and the error is telling you that it cannot find "sapbex.xla", then it is possible that the problem is related to macro security settings.

You have written that the macro security setting is "medium". Please also check the "Trusted Publishers" tab and click "on" the "Trust access to Visual Basic Project" (bottom left of the "Trusted Publishers" window).

If this is not clicked "on", and IF there is Visual Basic code that is looking for "sapbex.xla" by enumerating the open Visual Basic Projects, it would not be able to find it.

I hope this helps.

- Pete