Hi,

I have a workbook called matrixbook.xls that contains a seperate worksheet
for each day up to about 6 weeks ahead. After each day has been and gone I
need to open a workbook called archivebook.xls and move the sheets for the
day or sometimes days that have passed into the archivebook.xls

So its like this.

open archivebook.xls
move active sheets (the ones in matrixbook.xls) to archivebook.xls
save and close archivebook.xls

How do I do it please ?