TeachExcel

Auto-Delete Expired Excel Workbooks

Excel Project

The downloadable files for this project are available once you purchase it.

Questions? Contact Us

Price: $9.95 (usd)

Project Video > Auto-Delete Excel Files Video

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).


Project Video

Project Files