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 in 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-Surroundings when starting:

3_New_Project

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.

4_order sequence

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

5_Save

The following Note you confirm with Ja.

6_Note

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 .

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 is recommended to use the file then not again with Makro save.

 

commentary

read a comment

 

Transparency: This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de.

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