Deleting files on your drive with VBA is relatively easy. The ‘kill’ command is used but be careful, as the file is not sent to the Recycle Bin, it’s deleted forever. This example code will delete the file named datanology.xls in My Documents but you can change as you require, add it into a loop […]
