Deleting a File

[Steve]

Hi

The last part of my macro is a save command:
ActiveWorkbook.SaveAs
Filename:="H:\Personal\SIGINCUSTODY.csv", FileFormat _
:=xlCSV, CreateBackup:=False

I have a problem, however, in so far as a file of this
name already exists and I want to either:
a) overwrite it automatically (without being asked),or
b) delete it at the start of my macro.

The second option is my preferred option.

Can anyone show me how to do it ?

Thanks in advance

 

[Guest]

Kill "H:\Personal\SIGNCUSTODY.csc"

 

[Ron de Bruin]

Hi Steve

Look in the VBA help for the Kill command

Sub test()
If Dir("C:\rrr.xls") <> "" Then
Kill "C:\rrr.xls"
End If
End Sub

 

[Steve]

Thanks very much

-----Original Message-----
Kill "H:\Personal\SIGNCUSTODY.csc"




.