Thanks very much for the suggestion, I thought that might have been the way.
Unfortunately, I'm not savy with macros's and would have no idea how to do
that. Learning macros for this one of event is not practicle for me and it
sounds very involved. Do you know of a ready made macro that will do this
and also how to implement it?

Thanks for the reply anyway.

Mac53





"Don Guillett" wrote in message
...
Why not just put a macro in the before_save event of the ThisWorkbook
module so that it is done when they save. You can even create it so that
if they still continue to try to save another way, their desires are over
ridden.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mac53" wrote in message
...
My customer invoices are being made out by various people using excel.
When saving the invoices I've asked them to add the current date to the
filename when saving it,
such as AAA607 PLUS CURRENT DATE.
Problem is they enter the dates in different formats.
e.g. aaa6071107, aaa607010107, aaa6071/1/07, aaa60701/01/07.
Is it possible to get excel to add the current date to the filename
automatically for consistancy and so they can be later retrieved and not
overwritten.

Mac53