Link between Excel (VBA) - SAP (CJ20N)

[former_member1060878]

Dear,

I need your help for the following task please:

I would like to create a link between Excel and SAP for the transaction CJ20N to remove/add SAP code in the CJ20N with the information put in my Excel file.

If I have my Excel file and SAP already open, I would like to put a project number and a SAP code in my Excel file and with a Macro this remove OR add the SAP code mentionned in the CJ20N of the project number mentionned.

Thank you very much for your help, this will be very apreciate for me to kno if it possible and if yes, how can I do that.

Thanks!

Best Regards,

[mynynachau]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mynyna

SAP Community moderator

[former_member1060878]

Please, someone could help me because I'm completely blocked in my work 😞