VBA Delete File / Workbook

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 (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:

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