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
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Steve" wrote in message ...
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