Delete Method (Visual Basic for Applications)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Description

Deletes a specified file or folder.

Syntax

object.Delete force

The Delete method syntax has these parts:

Part

Description

object

Required. Always the name of a File or Folder object.

force

Optional. Boolean value that is True if files or folders with the read-only attribute set are to be deleted; False (default) if they are not.

Remarks

An error occurs if the specified file or folder does not exist.

The results of the Delete method on a File or Folder are identical to operations performed using FileSystemObject.DeleteFile or FileSystemObject.DeleteFolder.

The Delete method does not distinguish between folders that have contents and those that do not. The specified folder is deleted regardless of whether or not it has contents.