Auto-Delete Expired Excel Workbooks
Questions? Contact Us
How to go through an entire directory using Excel and automatically delete all files that have expired or are no longer valid.
The method that I show here allows you to delete an Excel file based on any set of criteria and I show you how to determine the criteria to use and where to change your code so that it checks what you need it to check before the file is deleted.
This is a robust and flexible piece of code but be carful! Files deleted using this method are not easy to get back (they will not be in the recycle bin).