excel 2003 visual basic intermediate course - Deleting a file

Hi Samantha

To delete a file from the system you need to know the name of the file to be deleted. then you instruct the system to Kill the file.

NB This permanently deletes the file from the hard drive. It doesn't put it in the Recycle bin.

The code is as follows as a example

Sub DeleteAFile()

Dim WbString As String

WbString = "C:\Documents and Settings\User6\My Documents\My Sheets.csv" 'The path of the file to be deleted

Kill WbString

End Sub

Hope this helps

Carlos