Be the first user to complete this post

  • 0
Add to List

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 : GetAbsolutePathName Method
  3. FileSystemObject : MoveFolder Method
  4. FileSystemObject : FileExists Method
  5. FileSystemObject : DriveExists Method
  6. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
  7. FileSystemObject : CreateFolder Method