• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Backup

Shabbo

Member
Dear Sir,
How to take auto backup daily for last saved file.
eg : If I wanted to take backup for my bank reconciliation file I have worked full day on the same file but I wanted to take backup for last saved only how to take that.
 
What version of Windows (or OS) do you use?

If using Windows 10. There is built in program for this called File History.
https://lifehacker.com/how-to-back-up-your-computer-automatically-with-windows-1762867473

If Windows 7, you don't have File History, but can specify which folder to make a back up of, using Windows Backup.

Though this largely depends on your access level on your network.

If not, you can always use one of free add-ins out there, that allows for version control (i.e. save with different version number each time a file is saved).

Or if it's specific file only, save a copy in a given folder, either manually or by code (i.e. use BeforeClose event on workbook to save a copy of the file).
 
Back
Top