SaveCopyAs (Excel 2007)
 

I wrote some code in a workbook for Excel 2003 to save a backup copy of the
file to a backup server every time the file was saved locally (it was called
from the Workbook_BeforeSave event). Although the filename is the same, the
path is different. This worked fine in 2003. However, if the file is
converted to the new macro enabled workbook in 2007, it works once. After
that it throws up an error (and deletes the backup that was there)! Sounds
like an Excel bug to me. Do I need to look for and delete any existing
backup before attempting to save it? I didn't have to do this in Excel 2003.