VBA Delete File

Associated Files Download Links

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:

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:

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