macro to copy data from a different application

[mvatoi]

hi all,

I need to create a macro to copy some data from SAP (similar to Access) and then paste back in excel. How do I do that?

Normally SAP is already opened,

I want to tell Excel macro to:

1) copy this customer # in A1, from excel spreadsheet (i know how to do this)
2) enter the # in SAP (there is a box, not a cell), hit enter, SAP will then pull up the data list,
3) copy the customer name in SAP
4) paste customer name back to cell B2 in excel.

Any help will be appreciated.

Thanks