I would like to create a macro to take a column of UPC numbers in a list in column A and look them up in SAP and return the material number our company uses. Many clients remit using the UPC number, but the Material number seems to be more useful on our end.
I picture this as a template that a list may be copied and pasted into column A and a macro run, and it would take the contents in, say A2 and copy it and paste it into the material lookup, enter, and copy and paste the returned value back into B2. Then it move to A3...B3 and continue until the entire list is converted.
Im not sure where to start with this, so any help would be appreciated. I do have a fair foundation working within excel and excel macros, just not making them talk to SAP. I have used something at a previous job that did something similar. In that case we opened the other application to the screen for the lookup, then pasted our list in the template and ran the macro. It would convert until the list was done.
To do this manually is time consuming.
Another, similar project I would like to do is to take a list of invoice numbers in an excel worksheet and have sap send those to the default printer. I think this should be able to be done in a similar fashion... Currently we have to send one at a time and long lists of 20-30 can be time consuming and menototnous.
Can anyone help?
I picture this as a template that a list may be copied and pasted into column A and a macro run, and it would take the contents in, say A2 and copy it and paste it into the material lookup, enter, and copy and paste the returned value back into B2. Then it move to A3...B3 and continue until the entire list is converted.
Im not sure where to start with this, so any help would be appreciated. I do have a fair foundation working within excel and excel macros, just not making them talk to SAP. I have used something at a previous job that did something similar. In that case we opened the other application to the screen for the lookup, then pasted our list in the template and ran the macro. It would convert until the list was done.
To do this manually is time consuming.
Another, similar project I would like to do is to take a list of invoice numbers in an excel worksheet and have sap send those to the default printer. I think this should be able to be done in a similar fashion... Currently we have to send one at a time and long lists of 20-30 can be time consuming and menototnous.
Can anyone help?
