Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I haven't kept track of the added/subtracted Excel features, but I was pretty sure in the older versions of Excel (2003) you could auto-save the file. In Excel 2013, you can only auto-save the AutoRecover version of the file. I found that although I have backup software backing doing incremental backups of critical spreadsheet folders where files have been updated, this is useless unless the user has saved the file to change the modification date. Why can't there be a save file function every 10 minutes? Or is there one hidden somewhere?
|
#2
![]() |
|||
|
|||
![]()
The way backup is not that way.
You need VBA to backup in that way. |
#3
![]() |
|||
|
|||
![]() Quote:
Last edited by Frasca : August 27th 22 at 08:59 AM |
#4
![]() |
|||
|
|||
![]()
"SaveWorkbookBackup” macro will create a backup of the Excel file with the “.bak” extension within the same folder where the active workbook is saved.
“SaveWorkbookBackupToFloppy” macro will create a copy of the active workbook in drive D which will act as a backup file for the active workbook. Code explanation If Not Ok Then MsgBox "Backup Copy Not Saved!", vbExclamation, ThisWorkbook.Name End If The above code is used for displaying an error message when some runtime error occurs during the execution of the macro. If AWB.Path = "" Then 'Displaying Save as dialog box for file saving Application.Dialogs(xlDialogSaveAs).Show The above code is used for displaying Save As dialog box if the file is not saved before taking the backup of the file. You can check more about VBA on https://www.apps4rent.com Let me know if this helps. Regards, Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2013 animation feature.... | Excel Programming | |||
Excel 2013 Merge Data | Excel Programming | |||
Help creating new functions for Excel 2013 | New Users to Excel | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
Auto Excel workbook close: save= false during an auto subroutine | Excel Programming |