Suppress warnings when saving text file?

  • Thread starter Thread starter Snowsride - ExcelForums.com
  • Start date Start date
S

Snowsride - ExcelForums.com

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
 
Application.DisplayAlerts = False

Make it true again before the workbook (.txt) is closed
"Snowsride - ExcelForums.com"
 
Application.DisplayAlerts = False
activeworkbook.SaveAs "c:\Myfolder\Myfile.csv", Fileformat:=xlCsv
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True
 
Back
Top