Vba delete files in a folder

Asterisk denotes multiple characters, a question mark denotes a single character, and a tilde denotes the identification of a wild card character. We have seen how we can delete a single excel file and all the excel files.

But if we want to delete all the files in the folder, how can we delete it. Since we are using Excel VBA, can it delete other files? To do this, the first thing we need to do is we need to delete all the files in the folder by using the KILL function and then to delete the folder, and we need to use one more function called RmDir. Here RmDir will delete only the empty folder if any subfolder is where it cannot delete them.

Below is the example code to delete the read-only files as well. Here we discuss the VBA Code to delete 1. Particular File Name, 2. All files, 3. Entire folder, and 4. Read-only Files with downloadable excel template.

Add a comment. Active Oldest Votes. Delmar Silva Delmar Silva 1 1 silver badge 6 6 bronze badges. While this code snippet may solve the question, including an explanation helps to improve the quality of your response. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. True, so better doing it like Ashok answer — Delmar Silva. GetFolder path. Files f. John Alexiou John Alexiou I've found what my problem is, I'm trying to delete all the files which automatically get saved into the C: Downloads on my computer so they're not in a folder within that location, just into users and then downloads.

Any ideas on how I can clear all my downloads through VBA? Please edit the question with the specifics and be clear of your intent. Maybe provide an example of before and after. If I put a folder within the location it will delete that folder but I want to clear all files within downloads. Does that make sense? Thanks, — Brentford I have edited the answer to show deleting of all the files in a folder first, and then the folder itself if needed. I hope you can adapt the above to your needs.

Both the examples will have one minute difference which I will explain at the end of the topic. First, we need to get a path for the sample 1 file. In order to do that right click on the file and from the properties option go to security and we will find the path to beside the object name as follows. Step 1: Now let us enter into VBA from the visual basic option. Step 2: Once we are in VBA we need to insert a module.

To enter the code window double click on the module which will take us to the code window. Step 3: Now the first step for writing a VBA code is to name the macro as follows. Step 5: Now let us assign the path to this string of the file we want to delete which is sample1. Step 7: When we run the above code and look at the desktop we can no longer find the first text file we created. Only the second file is present and the first file is moved. Run the above code again. VBA gives us a runtime error that the file is not found.

This is important which we need to keep in mind. Now let us delete the second file using the kill function. Again we need to have the path for the second file for which we need to right click on the file and from the properties option go to security and we will find the path to in beside the object name as follows.

Step 6: Now we will check that the file even exists using the If function as follows. Step 7: Now if we run the above code we can see that the file has been deleted and it is no longer in the desktop.