Hi.
I have a macro that backs up a user's custom data in a spreadsheet.
I would like to add something to the existing macro before it saves to:
1) check and see how many backups are already in the Backups folder and
2) ask the user if they would like to delete the oldest if there will be more than 5 copies after this one saves, and
3) If they say Yes, then deletes the oldest backup file(s).
Here is the current saving code:
Thanks!Please Login or Register to view this content.
Bookmarks