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

Icon_Excel10_33x32If 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 other 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 in the 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.

1_development tools

You have that hook and before Development tools set, you can now see this in the Ribbon. You can find that here too Symbolto get a VBA project zu start.

2_VisualBasic

Following View offers the VBA-Environment when starting:

3_New_Project

After a Double to this Workbook you give in right 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 has always been \ behind the path. This gives rise to the following possible View.

4_order sequence

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

5_Save

The following Note you confirm with Ja.

6_Note

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

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

7_Workbook_Macro

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.

8_secure

Would you like this Backup file times change and under a different name save, it then recommends the file not again with Makro save.

 

commentary

read a comment

 

___________________________________________________
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.