I have a report (report.xls) that is progressively automatically generated
each month as production batch sheets are generated and printed from my
workbook(s).

What I would like to be able to do is when the workbook is launched for the
first time on the first day of each month, save (save as) the report to a new
file, the name of which is last month (eg. September2005.xls). Then, clear
the contents of the worksheet which was being used to store the data
throughout the month (report.xls) and then start again for the new month. The
workbook may be opened and closed several times on the first day of the
month, so upon subsequent openings on the first day of the month, the system
would need to know that the monthly report has already been saved.