View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AwesomeSean AwesomeSean is offline
external usenet poster
 
Posts: 13
Default save twice command

The reason for the "hidden" file was not really to hide it from anyone
because everyone knows where the copy is just in case . We had a problem
where we work off of 1 file the whole week and update it several times daily.
well, last week on the last day, someone put the wrong weeks info in the file
and saved it so we lost everything for the previous week. I wanted to make a
back-up copy in a seperate folder everytime the file was saved just to have
for cases like this. Bernards code worked just how I wanted it too. Thank you
for the help.