How to work with CSV files in Excel without warnings?

[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

 

[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