I have an Excel file called "ABC Ltd" that users update on a daily basis.

Does anyone know know to auto create a backup at the end of a day?

If today is October 2, 2009, the back up file name will be "Backup of ABC
Ltd_20091002.xlk"

And at end of next day, auto create another backup called "Backup of ABC
Ltd_20091003.xlk" and so on the days to come.

Thanks

Igbert