Save backup of workbook before close

[jeffreybrown]

I was hoping somebody had a suggestion for how to solve this backup question.

I call the macro below from a Workbook_BeforeClose sub; however, if the user has not saved changes before they hit the close then the Sub SaveFile runs and then after the backup save they are then asked do you want to save changes.

I initially had this sub run with Workbook_BeforeSave, but I don't really want to run this everytime the user selects save.

Any ideas on how to how the save changes first and then the backup?

Please Login or Register  to view this content.

[davesexcel]

I Use this for a lot of workbooks, when the user closes the workbook, it kicks in, saves it to a Backup Folder and the date it was saved.

Please Login or Register  to view this content.

[jeffreybrown]

Hi Dave,

Thanks for the help.

This works great, but it doesn't address the saving of changes. If the user does not select save before they select close then after the backup kicks in they are then asked if they want to save changes yes or no. Is there a way to force the save changes to come first before the backup in lieu of maybe forcing the saved changes with activeworkbook.save.

I really don't want to force changes being saved in case they really did not want to save their most recent updates.

[davesexcel]

All they have to do is select no.