VBA for data extraction from sap

[dwarek]

Hi everyone
i need to built a VBA code to extract data from the sap and add those data into the excel file. I need to extract data based on the product number, Can anyone help me out how to do that.

Thanks in advance

 

[My Aswer Is This]

What is SAP?
And I would think I would need more details.

 

[farmerscott]

SAP= German software company????

Via Google- SAP is an Enterprise Resource Planning software (ERP) from the company SAP AG, Germany. SAP (or generally any ERP) is used in large or medium size enterprises to integrate the processes across various functions.

 

[Worf]

I use SAP at work but never automated it with Excel. This thread looks interesting:

https://stackoverflow.com/questions/19452461/vba-pulling-data-from-sap-for-dummies

Dwarek, tell me how it goes, I can also try on my end if you get stuck.