Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

VBA Code for comparing 2 material excel codes with material SAP code using VBA

0 Kudos


i am new member coming to group.

i have a question. i need to add some material code is alt code in SAP BOM but in BOM did not display material code exist or not when i searched it in BOM.

so i want to compare material excel code with first material SAP code after i searched it in BOM. If it's the same then save it and don't do anything. If it's different then do the next steps.

as attachment:

step 1: i need to add red code in to BOM

step 2: i searched code in BOM to check.

Step 3: copy red code in SAP BOM and compare it with excel file step 1, if it the same code then save it and don't do anything.

if it's different then do next steps.

can u help me, how can do it using VBA?


Active Contributor
0 Kudos

Is it Excel, VBA or ABAP question?