Hi all,

Can anyone tell me how to create a monthly backup of my file whe
autoclose is initiated? the file will most probably be used most day
of the week so after a month has passed when it is next closed i woul
like a back up copy to made to P:\public\training\development, bu
every month it makes a back up copy it needs to have a different dat
say "trainingBkUp7.7.04" and next month it would b
"trainingBkUp7.8.04" etc.

Can anyone help?

Simon.

P.S the Auto_close just updates the file and saves it to its curren
location and its current filename (Workbook.Save

--
Message posted from http://www.ExcelForum.com