I figured out how to open five workbook, count the number of rows, close them, and print out the results.

To do this, I only opened one workbook at a time, set it as active, saved the count in a variable, and closed the workbook.

What I want to do now, though, is make sure the dates align on every row. I want to do this with all five workbooks open at once. To do this, don't I have to give each workbook a name? If so, then how do I assign the name and do I have to dim that name?