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

Running BEX7 workbook repeatedly from excel vba

On a monthly basis I have about 300 reports to run,all from the same bex7 workbook, just with slightly different variables.

I was able to setup a macro in bex 3.5 that would refresh a report and fill in values into the SAPBEXqueries hidden sheet. This would adjust each time and save each report with an individual name. Saved me about 3 hrs of sitting and running each report manually.

My company is now upgrading to BEX7 and I am having difficulty getting my head around how to run the same workbook in BEX7 through a VBA Macro and pass the variables to it.

I understand you can use SAPBEXsetVariables to pass variables along to the workbook but what format do the variables have to be in to communicate successfully with the workbook

Would someone have an example of the process?

I do not have access to modify the query at all as I am an end user and I am forced to come up with a solution on my own.

Any help would be appreciated.

Thank you

Dan Gerling

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 06:07 PM

    Hi Dan, in the same situation I'm afraid. Just posted this in a similar thread:

    "Hi Alfredough, I'm afraid I'm in pretty much the same situation as yourself (although possibly slightly further down the line). The reason I add that possibility is because I'm pretty certain that SAPBEXsetVariables has been removed in 7.x.

    It looks like there are some cludges which can be done to work through this (possibly), but the entire comparison of bexanalyzer.xla to sapbex.xla seems to involve features being removed, rather than added.

    Here's the thread which seems to give a cludge, which I'm having trouble getting working: How to set variables values via VBA.

    There's also some work which someone's done here around script objects: List BEx Analyzer 7.X variables and generate the associated PROCESS_VARIABLES commands

    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.