Is there any feature/option built into excel that allows the auto-saving of version documents.
I am developing a vba app at the moment (first one) and for those times that something breaks or there is a piece of code that i used and then removed, i like to take a different version every half hour or so, but this currently involves going:
- File > Save As > mydoc v87.xlsm
- File > save as > myDoc.xlsm
Especially for the macro, if i didnt have to change the file name to create a version that would be fantastic.
I realise there is 3rd party software that will do what i want, but a built in feature would be excellent.
If not built directly into office, is there a local option available in windows 7. With extremely strict group policy and very minimal server space, the server option is not looking very appealing.
Any help would be greatly appreciated.