View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AmyTaylor[_32_] AmyTaylor[_32_] is offline
external usenet poster
 
Posts: 1
Default Saving backup file on file open


Hi everyone, and a happy new year.
I want to include some code in a spreadsheet, whereby when a
spreadsheet is opened it automatically creates and saves a backup with
the days date in the file name ?

Is it also possible to include whereby when the file is saved it saves
itself with the days date, and if there is more than one save per day
it saves a number on the file path ? eg: SavedFileBackup200601051.xls

Hope that either or both of these options are doable.
Thanks in advance
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=498631