How to name opened workbooks

Originally Posted by rorya

You only set aWb once, so it is the workbook that was active at that moment. It doesn't adjust as you open workbooks to always be whichever one is active. But you don't need it anyway - what you want, as shg said earlier, is:

For i = 1 To 5:
     Set Asset(i) = Workbooks.Open(Filename(i))
Next i

Got it.

Continuing on, I still get an error here:

    If Asset(1).Cells(j, 1) = Asset(2).Cells(j, 1) _
    And Asset(2).Cells(j, 1) = Asset(3).Cells(j, 1) _
    And Asset(3).Cells(j, 1) = Asset(4).Cells(j, 1) _
    And Asset(4).Cells(j, 1) = Asset(5).Cells(j, 1) Then

"Object doesn't support this property or method." I think I'm trying to use the Cells property on a workbook... is that a problem?