Skip to Content
author's profile photo Former Member
Former Member

BEX with VBA error 91

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 14, 2012 at 08:16 PM

    Hello Former Member

    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)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2012 at 12:22 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2012 at 01:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2012 at 02:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.