Saving txt files without questions

[Theo]

When I use the next commandline to save a sheet as a txt file:

ActiveWorkbook.SaveAs Filename:= "C:Program FilesNew-WayMMSBDR004IMPORTCORKOP.txt", FileFormat:=xlText, CreateBackup:=False

Then I get the question from Excel if the existing file must be overwritten.
I want it ALL automated. How can I get rid of this question?

 

[Andrew Poulsom]

Put:

Application.DisplayAlerts = False

before your SaveAs line, and

Application.DisplayAlerts = True

after it.

 

[Theo]

Thanks!! That does the trick.