FileSystemObject : DeleteFile Method

Description: 

This function Deletes a specific file.

Format : 

objectOfFileSystemObject. DeleteFile (filename [, force])

objectOfFileSystemObject : As the names says, it’s a FileSystemObject.

Arguments: 

• fileName
  • Mandatory
  • Type:     String
  • Name of the file to delete.

•     overwrite
  • Optional
  • Type: Boolean ( True: delete the file even if read-only attribute is set , False(default): it not delete the file if read-only attribute is set)

Function FnDeleteFile(strFileName)
       Set fso = CreateObject("Scripting.FileSystemObject")

       fso. DeleteFile (strFileName)
End Function

Call FnDeleteFile ("c:\New Folder\File1.txt")

Also Read:

1. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
2. FileSystemObject : CreateTextFile Method
3. FileSystemObject : FolderExists Method
4. FileSystemObject : GetFileVersion Method
5. FileSystemObject : GetAbsolutePathName Method