How can I suppress the warnings that Excel displays when saving a tex
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: Ye

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

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 change
have been mad

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

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

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

Application.DisplayAlerts = False
activeworkbook.SaveAs "c:\Myfolder\Myfile.csv", Fileformat:=xlCsv
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"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