Skip to Content
avatar image
Former Member

Copy / paste macro from excel to SAP

Hi,

I'm newer to VBA. I need to do a mass change of about 3000 sales orders. Therefore I would like to have a macro that copies 3 different columns from excel into sap

Sales order # - Data 1 - Data 2

Copy sales order from excel - do transaction /nva02 - paste

copy Data 1 in excel - paste in Sap

copy Data 2 in excel - paste in Sap

And if possible to have an additional column to confirm if order is updated (ok)

Next sales order etc until last row

The excel sheet will be used by multiple people users Something like Active workbook would be more helpful than a path

I am aware that there are similar threats but more the other way around

Could you please help providing a VBA code I know how to do Script recording

Thanks a lot in advance

Alex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers