cancel
Showing results for 
Search instead for 
Did you mean: 

The BEx Analyzer cannot generate VBA code due to the security settings

Former Member
0 Kudos

Hello experts,

when I try to open a query in BEx Analyser I get this error message for each Item of the Query:

-


Diagnosis

The BEx Analyzer cannot generate VBA code due to the security settings.

System Response

VBA code is not generated.

Procedure

Choose Tools -> Macro -> Security.

On the Trusted Publishers tab page, select Trust access to Visual Basic project.

Choose OK.

Close the BEx Analyzer and continue working as before.

Access to Visual Basic project is only needed when generating VBA code.

This only takes place in design mode or when 3.x workbooks are upgraded.

-


Of course I did exactly what was recommanded in the "procedure-section" of this error message. But BEx ist still not working!

I use SAP NetWeaver 7.0 together with MS Excel 2007

Thanks

Axel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Axel

You might be using excel 2007 with Service pack. What we have normally seen if that Bex and Excel 2007 SP does not work well together. You might need to reinstall your excel version.

Thanks,

Answers (1)

Answers (1)

hai_murali_here
Advisor
Advisor
0 Kudos

Dear Axel,

If you are with Excel 2007 then to enable the Security Settings,you can go to

Excel 2007->MS Office Button(Top Left corner of the screen)->Excel Options->Trust Center->Trust Center Settings->Macro Settings->Check "Trust Access to VBA Project Object Model" checkbox

Rgds,

Murali

Former Member
0 Kudos

Hello MuraliKrishnan,

that is exactly what I did. But it did not work!

hai_murali_here
Advisor
Advisor
0 Kudos

Hi Axel,

Have you disabled all macros under Macro Settings?

Rgds,

Murali

Former Member
0 Kudos

Hey,

I am having the same issue as you are. I've tried setting my macro settings to enable all macros, and checked off the checkbox described in the error message.

Did you manage to resolve your issue Axel?

Thanks,

Jameel

Former Member
0 Kudos

Hey,

I am having the same issue as you are. I've tried setting my macro settings to enable all macros, and checked off the checkbox described in the error message.

Did you manage to resolve your issue Axel?

Thanks,

Jameel

Former Member
0 Kudos

Hi JameelM,

as RadhaN suggested you might reinstall your Excel. I downloaded the latest SAP GUI version and reinstalled GUI+BEx together with Excel 2007. This worked fine for me.

Axel

Former Member
0 Kudos

Hi Axel,

We are currently having the same problem. We are using SAP GUI 7.10 patchlevel 11, BI addon 7.10 SP 4 and Excel 2007 SP2.

Which versions did you install in order to fix this problem?

Thanks.

Best regards,

Linda

hai_murali_here
Advisor
Advisor
0 Kudos

Hi Linda,

Can you install Front End Patch 1001 which is available in SMP.

MS Office Excel 2007 (12.0.6331.5000) MSO (12.0.6320.5000).

Rgds,

Murali

Former Member
0 Kudos

Hi Murali,

We are working via Citrix so I cannot uninstall MS Excel and install a earlier version.

Do you know if there are any fixes from SAP available to solve this issue?

BR,

Linda

hai_murali_here
Advisor
Advisor
0 Kudos

Hi Linda,

I just searched for Notes related to VBA Macros and got the following Notes.

492561,216178,1256580.

This might help you...And also you can ask your Citrix Admin to give a rights to install the Excel 2007.

Rgds,

Murali

Former Member
0 Kudos

Hello experts,

I am an additional person interested in the way this issue was solved.

I confirm that the issue is coming from the SP2 of Microsoft Office (I have another environnement without the SP2 and everything works well), and I am in a situation where I can't remove the update.

Regards

Guillaume P.

EDIT :

Solution found : I applied the bi710sp10p_1001-10004472.exe patch

(downloaded via the download maanger : Support Packages and Patches - Entry by Application Group" SAP Frontend Components" BI ADDON FOR SAP GUI" BI 7.0 ADDON FOR SAP GUI 7.10)

Edited by: GUILLAUME PETIAUX on Apr 13, 2010 10:29 AM