Always Create Backup-Specifiying Path

[annedaugherty]

I am trying to save a backup file whenever I close my Excel workbook. This I can do with no problem. I wish to save a copy of it to a different directory on the network.

Is there a way to do this?
Thank you for your help

 

[RobBroekhuis]

Add an eventhandler to your ThisWorkbook code module:

sub Workbook_BeforeClose()
application.displayalerts=false 'to automatically overwrite
thisworkbook.saveas SaveFolder & "\" & thisworkbook.name
application.displayalerts=true
end sub

Rob