Suppress warnings when saving text file?

  • Thread starter Snowsride - ExcelForums.com
  • 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
 
M

Mike Fogleman

Application.DisplayAlerts = False

Make it true again before the workbook (.txt) is closed
"Snowsride - ExcelForums.com"
 
T

Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top