VBA Delete File
VBA allows you to delete an existing file, using the Kill command. In this tutorial, you will learn how to delete a specific file or multiple files.
If you want to learn how to copy and rename a file, you can click on this link: VBA Copy File
Delete a Single File in VBA
We will show how to delete the file Sample file 1.xlsx in the folder VBA Folder. The folder with the file now looks like in Image 1:
Image 1. Delete a single file
Here is the code which will delete the file:
Kill "C:\VBA Folder\Sample File 1.xlsx"
After running the code, the file Sample file 1.xlsx is now deleted from the VBA Folder. The output is in Image 2:
Image 2. File deleted from the C:\VBA Folder
Delete All Excel Files From the Folder
The same command enables you to delete all Excel files from the folder. You just need to put an asterisk (*) instead of the file name. An asterisk replaces any string. Here is the code:
Kill "C:\VBA Folder\*.xlsx"
As you can see in Image 3, all Excel files from Folder VBA are deleted:
Image 3. Delete all Excel files from the C:\VBA Folder