Excel VBA Macro To Remove a Desired Excel File From Directory or Folder
'Let us suppose if you want to delete a Excel File named "MyXlFile" loacated in My Documents
'You can use the KILL statement to delete a file
Dim P As String
P = "C:\Documents and Settings\Administrator\My Documents"
Kill P & "\" & "MyXlFile.xlsx"
'You Can Specify Your Desired Path Where Your Excel File Is Located
'You Should Should Delcare Flename(Eg: MyXlFile.xlsx") with Extension