Hi there
I have a macro which performs the auto save function perfectly. I'm looking at possible enhancements and would like some suggestions please
1. How to set autorecover save location in VBA?
I know how to do this on the front-end i.e goto tools/options/save tab and set it there
As i have disabled save autorecovery feature, autorecover save location is greyed out
2. How to create a backup of my workbook?
So that my workbook will perform autosave and when i close this workbook at the end of the day all the latest changes are added to the backup and saved
please advice
Bookmarks