Delete Excel Workbook

[PM312]

How can i deletete excel file saved as "D:\PRLIST.xls" through VB Code.

[aktharshaik]

Hi,

You can delete any file from the disk using the KILL command

Syntax:
KILL <filename with path>

Before deleting any file you can check if it exists in the path or not first.

If Dir("D:\PRLIST.XLS", vbNormal) <> "" Then
        If MsgBox("DELETE FILE?", vbYesNo + vbInformation, "DELETION") = vbYes Then
            Kill "D:\PRLIST.XLS"
        End If
    Else
        MsgBox "No Such File Exists."
    End If

Regards
Shaik Akthar

[debasisdas]

You cam also use FileSystemObject.

[PM312]

Thanks