I have a spreadsheet which is used daily by the night shift. I want to save a
copy of the workbook to a certain folder with todays date appended to the end
of the filename when they have finished their shift (06:00'ish). In addition,
if the file already exists I want it to automatically overwrite the file but
only if the time is before 21:00 (so that if they use it and close it at the
start of the following shift I dont lose the previous days data). I need this
to be independant of user involvement.

I think I need an event handler procedure but its a bit beyond me!

Thanks in advance....