can you please tell me how i can delete a file from within excel vba?

the file is a .csv file or a .cap file (this is just a file with a .cap extension and is in effect a text file). After i do all the formatting on the file and paste it into another worksheet, i need to then clear down this file by deleting it.

can anyone please tell me how?

thanks
sam

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

thanks for this carlos.. another question answered!!
sam