#1   Report Post  
Old October 1st 14, 11:51 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2014
Posts: 1
Unhappy Excel 2013 Auto Save

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   Report Post  
Old January 19th 18, 05:12 AM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 16
Default

The way backup is not that way.
You need VBA to backup in that way.
  #3   Report Post  
Old August 4th 18, 04:10 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2018
Posts: 1
Default

What's VBA? Please forgive my 'newbiness.' I'm having issues with backups.
  #4   Report Post  
Old December 28th 20, 09:04 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Try this:

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2013 animation feature.... XR8 Sprintless Excel Programming 2 June 10th 14 10:39 PM
Excel 2013 Merge Data jfcby Excel Programming 2 April 16th 14 04:03 PM
Help creating new functions for Excel 2013 Jschock New Users to Excel 4 August 20th 13 01:25 AM
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL T-mo Excel Discussion (Misc queries) 1 January 12th 06 11:16 PM
Auto Excel workbook close: save= false during an auto subroutine tomwashere2 Excel Programming 10 June 16th 05 06:23 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017