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.
Below is my code that keeps the newest intFiles2Keep backup files in a subfolder named Backups. It requires a reference to MS Scripting Runtime - it assumes that all the backups in the target folder are backups of the same file. You can modify the code to check the non-date part of the file name if that is not the case. I run this as part of the actual backup routine, so it never needs to look for more than one file - if you haven't cleaned out the folder in a while, it will remove multiple files - just not efficiently
Use the code like
CleanUpBackups ThisWorkbook.Path, 5
You can modify the interaction to ask the questions you want - though most users overestimate the number of backups they need or will ever use.
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Thank you for your help. I will give this a try tomorrow and let you know how it goes.
I do not understand where to enter this line in the code.Originally Posted by Bernie Deitrick
You can use that anywhere you want, like right after saving the backup: ( I changed ThisWorkbook to wkbTarget since I'm not sure which workbook is which - that should work with your code, without seeing all of your code.)
Please Login or Register to view this content.
Great! I understand. Thanks so much.You can use that anywhere you want, like right after saving the backup: ( I changed ThisWorkbook to wkbTarget since I'm not sure which workbook is which - that should work with your code, without seeing all of your code.)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks