in reply to Comparing two excel workbook and copy the values if the cell are match
It would be considerably easier to simply do this in Excel itself. The BASIC scripting could be put in either spreadsheet or in a third one which opens the other two as objects.