BEX with VBA error 91

[#1]

Dear Experts.

My computer, in the client, was recently updated to Windows 7 + MsOffice10 and the workbooks I´ve created in the BEX are not working anymore.

The workbooks are from input queries and when I click in one of the enter values comes the message bellow and then the excel/BEX is terminated.

The SAP GUI is 7.20 and patch level is 11.

ERROR MESSAGE (VBA message in a free translation):

Execution error 91

The object variable or bloc variable 'With' not defined.

Thanks in advance,

Abbud

[sapna_jgurudutt]

Hi  Abbud,

Can you please refer the following note and check whether it helps you:

1050605 - No response for the toolbars in BEx Analyzer

Thanks & Regards,

Sapna

[arvind_doomra]

Dear Ricardo,

a runtime error '91': Object variable or With block variable not set occurs if the frontend installation is damaged.

With a new installation of frontend the problem should be solved. I recommend a complete installation as described here:

> Complete Installation SAP GUI 720 + Frontend
     http://wiki.sdn.sap.com/wiki/x/CIENDw

Currently following patchs are available:

> SAP GUI for Windows 7.20 patch       13
  BI AddOn Patch for GUI 7.20          901
  SAP BW 3.5 AddOn Patch for GUI 7.20  13

You can download the patchs in the SAP Market Place, please start navigation from our SDN page:

> Current BI ADDON FOR SAP GUI 720
  http://wiki.sdn.sap.com/wiki/x/wQ8MDg

Regards,

Arvind

[arvind_doomra]

Please also implement below note:

1581228 - BExAnalyzer : VBA error 'Project or library can not found'

[former_member182470]

You can get in touch with your BASIS and show the error message.

[TammyPowlas]

Hello

This is the BI space

This question belongs in the Business Explorer space.

I will move this thread. 

Please post questions in the most detailed space in the future.

Regards,

Tammy (Moderator)