Save .csv with overwrite

K

Kevin

I need to modify a .csv file and save it via macro,
without prompting the user about whether to overwrite or
not. I can't find anything in the save method for this,
and overwrite appears to be limited to the copy function.
How do I do this?

Thanks in advance,

Kevin
 
M

mudraker

This will save your active book as a csv file


Application.DisplayAlerts = False

ActiveWorkbook.SaveAs FileName:= _
"D:\My Documents\Book1.csv", FileFormat:= _
xlCSV, CreateBackup:=False

Application.DisplayAlerts = Tru
 
Top