Skip to Content
Former Member
Jun 17, 2016 at 01:53 PM

BEx Web and VBA


Hi Everyone,

I am new here and I am an absolute beginner in SAP and VBA. I hope to become like you guys one day 😊

I have to run a report on a daily basis using BEx Web.

Once in BEx Web (picture attached), I have to amend different variables such as the calendar day, the site (A), and the sales organization (A).

Once the variables selected, I have to press OK. This will direct me to another page with the data.

I have then to export the report as Excel, download it.

Is it possible to get a VBA code for all of this :

- Change Variables in BEx Web

- Click OK

- Once in the other page, click export as Excel file

- Download the excel file locally

That would be a huge favor !!!!

Thanks in advance



BEx Web.PNG (16.5 kB)