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

SAP BEx Variable Screen inputs through VBA

Can some on help on how to give inputs to the SAP BEx Analyzer variable screen through VBA or VB.Net ?

when i say refresh query it is giving a pop-up screen where i have enter some mandatory fields in the the screen. please help on this if there is a way to handle this process to automate through VBA ot Vb.Net .

Thanks a Bunch.

Sukumar Challa

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 21, 2010 at 11:58 AM


    I think you have ENTERED some ERROR. If you enter any undesired PARAMETERS the system may give VBA error. Firstly you IDENTIFY what is the desired VARIABLE inputs to be supplied.

    For Exp: If the input is 10-2010 and if you enter 10/2010 the SYS may throw this error. -This is a error from Presentation Layer.

    Hope this is useful..


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashok,

      i was not talking about the ERROR in the input. This variable screen is a type of input where we can give our required inputs dynamically. of course we have query in excel sheet, but when you say refresh it will pop up a SAP BEx variable screen window there it will ask for the dynamic values of the query.

      that is what i am talking about.



  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2010 at 01:12 PM


    1-Open your vba window.

    2- View -> Properties window

    3- on your VBA Project, you will see Sheet1 (SapBEXqueries)

    4- Click on it, and in properties change Visible field: xlSheetHidden --> xlSheetVisible

    5- On excel, you can now see the Sheet SAPBEXqueries. Look at column FZ (about) and you will see

    a list of variables. you can enter value with your VBA code and refresh all your queries.

    Other modification: for each query of your workbook:

    Change the properties to select "Save and reuse variable values"



    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.