How to work with CSV files in Excel without warnings?

S

Samuel R. Neff

We work with a lot of CSV files in Excel and would like to turn off
the warning that the file "may contain features that are
incompatible..".

Is it possible to allow saving a CSV file without warnings?

Thanks,

Sam
 
B

Bernie Deitrick

Sam,

You could use a macro:

Sub TryNow()
Dim myFName As String
myFName = Application.GetSaveAsFilename(, "*.csv,*.csv")
If Right(myFName, 4) <> ".csv" Then myFName = myFName & ".csv"
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs myFName, xlCSV
Application.DisplayAlerts = True
End Sub


HTH,
Bernie
MS Excel MVP
 
Top