I have some code that opens three workbooks simultaneously. Two workbooks
will contain source data while the third is the workbook to which I want to
copy source data. The destination workbook is not really a problem as it
will always have the same name so I can use that in the code. The two
workbooks with the source data will have names that change from week to week.
The name will be something like "Workbook Name_mmddyy" - the date being the
date on which the file was created. I will need to activate each of these
source workbooks in order to copy data. How do I reference the workbooks
when I don't have a name?

Thanks-