Vba delete files in directory

Generally while dealing with the file operations we create or delete files using VBA in the process. For example when we are automating a specific task, we create lot of intermediate files and finally we produce one final output. At end we clean or delete all the intermediate files using VBA.

Sometimes we may regularly monitor outlook and when we receive a new mail with required input files. We will save these files in a specific folder to process these files and produce the final output.

And we will check before saving the input files in the folder and delete if there are any existing files are already available in the directory. Follwing are the examples to delete a specific file or files from a location. Following is the example to delete a specific file from a folder or a directory.

First it will check whether the file exists in the sourse location or not. If it exists it will delete from the directory ot it will display message. Case 1: If file does not exists in the source location to delete, It will display following message.

Case 2: If file is exists in the source location, It will delete the file from source location. And it will display following message. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

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.

You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? And one scenario is when we usually receive an email. We save attachments for our regular work, or we just want to see the report for that point of time, and later we may need to delete those files. Deleting those files manually will take the time, or we may forget to save, and it will occupy the space on our computer. You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution?

A simple KILL function will delete the folder, specific file, all excel files, etc. The kill method cannot delete read-only files. Path Name: pathname is nothing but the folder path in the computer to delete the files. Note: Pathname can include wildcard characters as well. 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?