I am using a macro to update a database. At the end of the update, I would like for the macro to automatically save the entire excel workbook (name of workbook is ‘EARN’.xls) with an extension of .bak instead of .xls with the file saved to a specific folder(named BACKUP) within 'My Documents'. Does anyone have a routine that I might use to accomplish this that I can slip into this macro?