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?
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?