Skip to Content
0

Copy / paste macro from excel to SAP

Mar 26 at 06:03 AM

15

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers