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 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.
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.
Following View offers the VBA-Surroundings when starting:
After a Double to this Workbook you give in right-wing Window the following Command sequence .
Four-color Excel
|
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 times change and under a different name save, it is recommended to use the file then not again with Makro save.
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.