Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
Probably not. Is a macro an option for you? –  DaveParillo Nov 20 '09 at 22:41

1 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
share|improve this answer
    
would Left(.FullName, Len(.FullName) - 3) & "csv" mean in case of a foobar.xlsx a new filename foobar.csv, right? this omits the save dialog, and having custom names, right? in that case it is worth to note that if your workbook 'file' contains multiple worksheet 'tabs', then CSV can only can save the active one. and this would be better if addressed with the naming in my opinion, if possible! (unfortunately not a macro guy myself yet) –  naxa Feb 13 at 10:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.