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

[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'