Backing up Excel Files to a different Directory
- by Joe Taylor
In Excel 2007 in the Save As box there is an option to 'Create a Backup' which simply backs up the file whenever it is saved. Unfortunately it backs up the file to the same directory as the original.
Is there a simple way to change this directory to another drive / folder?
I have messed about with macros to do this, coming up with:
Private Sub…