Application.DisplayAlerts = False

Make it true again before the workbook (.txt) is closed
"Snowsride - ExcelForums.com"
wrote in message
...
How can I suppress the warnings that Excel displays when saving a text
file?

These are the messages displayed when saving the file as text:

"The file already exists. Do you want to replace the existing file?"
RESPONSE: Yes

"myfile.xls may contain features not compatible with Text..."
RESPONSE: Yes

These are the messages displayed when closing the file:

"Do you want to save the changes you made?"
RESPONSE: Yes or No - can enter either as no further changes
have been made

"The file already exists. Do you want to replace the existing file?"
RESPONSE: Yes or No - can enter either as no further changes have
been made

Thanks
---------
Message sent via www.excelforums.com