Hello!
On this thread I got some tips on a code for a weekly backup:
https://www.mrexcel.com/forum/excel-questions/1029101-complete-backup-macro.html?highlight=backup
However, I would like to add the function that makes the macro delete old backup files if there are more than 10 old backup files in the folder (so it only keeps 10 backup files in the folder all the time). Can anyone help me adjust the vba code to make it work and if possible also make the code autosend the excel file to a certain e-mailadress on a monthly basis? Thanks!!!
On this thread I got some tips on a code for a weekly backup:
https://www.mrexcel.com/forum/excel-questions/1029101-complete-backup-macro.html?highlight=backup
However, I would like to add the function that makes the macro delete old backup files if there are more than 10 old backup files in the folder (so it only keeps 10 backup files in the folder all the time). Can anyone help me adjust the vba code to make it work and if possible also make the code autosend the excel file to a certain e-mailadress on a monthly basis? Thanks!!!
