Delete file vba filesystemobject

Now let us start deleting files by looking at a few examples below. It is done by moving to the files section and then to the options section. Now let us move ahead to examples. For example, I have two files named sample 1 and sample 2. Both are text files and are on desktop. Have a look at them below. Let us first delete the sample 1 file in this example.

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. 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. Below are some useful articles related to VBA —. Forgot Password? Free Excel Course. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Privacy policy. The following code illustrates how the FileSystemObject object is used to return a TextStream object that can be read from or written to:. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Skip to main content. This browser is no longer supported.