Excel 2010: Back up the file to another partition at the same time

If you work with Excel on an extensive Workbook, and would like this to be on the safe side with every save process Automatically additionally on one others Partition secure, this is with a little VBA-Skript possible. To do this, the master file must then be saved as a workbook with a macro.

 

Once you have started Excel, you can use the key combination Alt + F11 into VBAEnvironment (Visual Basic for Applications).

A second option would be to add the development tools to the ribbon. For that one goes over File > options. > Ribbon to adjust.

You have that Hook off Development tools set, you can now see this in the Ribbon. You can find that here too symbolto get a VBA project zu start.

Following View offers the VBA-Surroundings when starting:

After a Double to this Workbook you give in right-wing Window the following Command sequence .

 

 

Option Explicit

Sub Workbook_BeforeSave (ByVal SaveAsUI As Boolean, Cancel As Boolean)

Application.EnableEvents = False

ThisWorkbook.Save

Application.DisplayAlerts = False

ThisWorkbook.SaveCopyAs "Drive: \ folder \"& ThisWorkbook.Name &" .xls "

Application.DisplayAlerts = True

Application.EnableEvents = True

End Sub

Under Drive and folder enter the path where the backup is to be stored. Important is the \ behind the path. This gives rise to the following possible View.

Now it has to Projects saved will. About the little one Diskette this is possible in the menu.

The following Note you confirm with Ja.

The VBA-Surroundings after saving, you can simply use the X top right schließen.

The Master file must as Excel-Workbook with Makro can be saved. This is selected via the Drop-Down-Menu under File Type .

If you work on this file and then save it, you will see the automatically created backup copy on the other partition or the external hard drive.

Would you like this Backup file little- change and under a different name save, it is recommended to use the file then not again with Makro save.

 

 

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.