Hi
try
Sheets("AccessTable").Select
Cells.Select
application.displayalerts = false
ActiveWorkbook.SaveAs Filename:="C:\Data\RV
Reserve\AccessTable.txt", _
FileFormat:=xlText, CreateBackup:=False
application.displayalerts = True

--
Regards
Frank Kabel
Frankfurt, Germany


Paul wrote:
Hi-

I wrote a Macro to automatically save a sheet in a text
file output format. This is the code used:

Sheets("AccessTable").Select
Cells.Select
ActiveWorkbook.SaveAs Filename:="C:\Data\RV
Reserve\AccessTable.txt", _
FileFormat:=xlText, CreateBackup:=False

How can I stop Excel from asking if I want to replace the
existing saved file?