How can i deletete excel file saved as "D:\PRLIST.xls" through VB Code.
PM312
30
Junior Poster in Training
Recommended Answers
Jump to PostHi,
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 …
All 3 Replies
aktharshaik
16
Posting Whiz
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 IfRegards
Shaik Akthar
debasisdas
580
Posting Genius
Featured Poster
You cam also use FileSystemObject.
PM312
30
Junior Poster in Training
Thanks
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.