Getting Data SAP Table to Excel Worksheet

[rafeemd]

Hi,

I am new to Excel programme (VBE), i have an urgent task.

i am not familiar with VBE. I am new to this.

How to connect SAP tables through excel worksheet and get the data from SAP table to excel sheet.

example :
Excel sheet having the data
A B C D E
123 abc xyz pqr
121 acb yyy xxx

the value of col A will be passed to SAP table and get the relevant filed value from SAP, the value wil be pasted in col E.

If possible post a code for above task.

Thanks in advance.

[snb]

Please post a sample workbook and a sample of the SAP data.

[rafeemd]

Thank You for early reply.


i am attaching the two xlsx files.
MM - is excel sheet
SAPdata - SAP table like

in excel worksheet the field 'Local Name' will be retrived from SAP table where 'Trade Code' matches.

If possible sent me entire code for the above.

Thanks a lot.

[rafeemd]

the attachments.