VBA Delete File / Workbook

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 (or Workbook) 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