Take single data from SAP - transaction MMBE and export it to Excel

Hi all,

I have an excel workbook, and in cell A1 there is a material reference. I would like to have an excel macro that looks for the parts that are in stock in SAP transaction MBBE from the reference shown in the cell A1 and then export from SAP the number of parts in stock to cell A2 in Excel. Which vba excel code could achieve this automatically? Is it even possible?

In case could not be possible... Can I download the stock from MBBE of all the part numbers in SAP and paste it to a workbook sheet called "Sheet 2"? How could be the code please?

Thank you all in advance for your help

Thank you for your message JeteMc.

I know what to do once data will be in the Excel sheet. My biggest concern is how to download the data from SAP.

For me it would work to download from SAP all the parts in stock if it is more easy.

Maybe there are other forums more suitable to ask these kind of SAP things?