VBA overwrite csv file if it was created today, else create a new one

[knifey]

Hi,
I have som VBA code that creates a csv file with todays date. Can anyone offer any advice on how to overwrite this csv file (without the user being prompted) if it is still the same date?
Thanks,
Roy

 

[combo]

Use DisplayAlerts:

Application.DisplayAlerts=False
' SaveAs the file
Application.DisplayAlerts=True

The Kill statement before saving is an alternative method.

combo

 

[nnett]

I have used the following code for somthing similar

Application.DisplayAlerts = False
FileStamp = FileDateTime("\\XXXX\XXXX\XXXX\XXXXX.CSV")
FileDate = Mid(FileStamp, 1, 10)
TodayDate = Mid(Date, 1, 10)
If FileDate = TodayDate Then
	~code to save file~
end if

Application.DisplayAlerts = True