Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?

Question

I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file:

"[your spreadsheet] may contain features that are not compatible with CSV (Comma Delimited). Do you want to keep the workbook in this format?"

My answer is always going to be YES. Is there a registry setting to suppress this confirmation dialog?

Answer 1

This is a common problem all Excel users suffer. I think, the only way to do that is to use a macro. For example:

Application.DisplayAlerts = False
With ThisWorkbook
    .SaveAs Left(.FullName, Len(.FullName) - 3) & "csv", xlCSV
End With
Application.DisplayAlerts = True