Marco to extract a parametre from excel and then have it entered in SAP to run a report

[Former Member]

Hello to SAP community of experts!

I hope to get a solution to my query.

I have a list of Plant no.s on an excel file which I use to run MB51 report. Since I have many plants, I want to automate the steps i.e.

1. Extract the Plant# from the excel file at cell A1
2. Access SAP
3. Go to MB51 transaction in SAP
4. Insert the Plant# in the plant field
5. Select the Posting date parameter and enter the From and To dates
6. Execute the Report
7. Go to Detail List view
8. Download the report with the name of the Plant# to a specific location or Append it to an excel file such that I just have one excel file where reports for all plants are dumped in a single sheet one after another. (which ever solution is available)
9. Repeat Step 1 where the focus will now go to cell A2 i.e. the next plant# (need to ensure that macro runs until reports for all the plants in the column A have been generated.)