Delete rows based on match criteria in two excel files or single Excel File

[DocAElstein]

OK, you seem to be trying to save all the files at once. That is not so easy to do.

arrWbs() is just text. Inside it, it just looks like this:
" C:\Users\WolfieeeStyle\Desktop\A.xlsx _ , _ C:\Users\WolfieeeStyle\Desktop\Files\B.xlsx "

You can’t apply any property action command to a piece of text


In my macro, each time the loop is done, the Workbook object, Wb is made from the string path and name of a workbook, ( which is held each time in the variable Stear ).

You know how to save and close a single Workbook with like
Wb.Save
Wb.Close

So you need to have those code lines inside the loop which is done For every workbook

So then Each time it will save Each workbook

     Wb.Save
     Wb.Close
    Next Stear
End Sub

Example in this file:

Macro2.xlsm : https://app.box.com/s/t35238lm19bj6y0p6m6p68uaknsdf37z

---

That’s all I have time for today.
Before you post any questions again, think more carefully , and read what I write…