Delete Old Excel File

Hello,

here an example, how to find the oldest file in a folder. The first code is the function which is looking for the oldest file. The 2nd code is the sub to call this function.
In the 2nd code you just have to insert your path to the folder.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Instead or after the msgbox you can enter the code to delete the file.

You are welcome. Glad to help.