Save last 5 to 10 file (same file) automatically for back-up excel

[nicholes]

some times i messed up with my excel file and realize it later

I want to keep save last 10 file or any number of file to be saved automatically.

I am not talking about recent or last 10 DIFFERENT FILES i have worked on

I am talking about one specific file which, when ever i save it, it should save like SAVE AS or some thing like that but only last few files


BTW save as meaning that i am creating large no of files unless i delete them manually and i dont want to do that

I have already checked for always keep back up, which is saving last one file only, I want to make same function but it should keep 10 file at least

Thanks

[JBeaucaire]

Put this into the ThisWorkbook module of your workbook, the workbook will have to be saved as a .xlsm file.

Please Login or Register  to view this content.

This will make 10 backups. If you only want 5, change the 9 to a 4.

[JBeaucaire]

Better yet, use this version.

Please Login or Register  to view this content.

[nicholes]

None of these worked for me

I know i am making some mistake in applying your trick as i am noob in it

here is what i did

i click on developer tool then Visual basic>right click on "This Workbook" insert > Module> and then paste your (both ) codes and save as .xlsm file.

Note:- Macro is already enabled and saved as .xlsm file

[JBeaucaire]

The code provided goes into the ThisWorkbook module, not Module1.

[nicholes]

The code provided goes into the ThisWorkbook module, not Module1.

That worked!!!

Thanks man

Reputation added

Cheers!!!