Delete worksheet after time period

[traub86]

I'm trying to run vba code to delete worksheets 2 years from the date they were created. The code I have inputs the date it was created so I would need the 2 years to be from the date in each individual worksheet. Here is the code I have thus far:

Sub ExportToMasterFileChalk1()
    Workbooks("JMPI MANIFEST.xlsm").Sheets("Chalk 1").Copy before:=Workbooks("DO NOT DELETE_MASTER JMPI MANIFEST.xlsm").Sheets(1)
    Workbooks("DO NOT DELETE_MASTER JMPI MANIFEST.xlsm").Sheets(1).Name = Format(Date, "DDMMMYYYY") + " Chalk 1"
    
End Sub

 

[Joe4]

Re-posted: https://www.mrexcel.com/forum/excel-questions/1032042-auto-delete-worksheet-after-period-time.html

In the future, please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you not to bump a thread more than once a day.