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