When saving CSV excel always prompts about the file format
 

I work with a lot of csv files all day and they have to be this format for
other applications and scripts to use them.

Everytime I save Excel prompts "filename.csv may contain features that are
not compatible with csv, do you want to keep this format". This is the case
even with Control S. The only formating is that I make the columns big
enough for me to read whats in each cell.

Anyway - can I turn off this prompt so that Excel just saves the file as csv?

Thanks,
Simon

When saving CSV excel always prompts about the file format
 

Try this before the save

Application.DisplayAlerts = False

and reset it after the save

Application.DisplayAlerts = True

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SimonW-UK" wrote in message ...
I work with a lot of csv files all day and they have to be this format for
other applications and scripts to use them.

Everytime I save Excel prompts "filename.csv may contain features that are
not compatible with csv, do you want to keep this format". This is the case
even with Control S. The only formating is that I make the columns big
enough for me to read whats in each cell.

Anyway - can I turn off this prompt so that Excel just saves the file as csv?

Thanks,
Simon

When saving CSV excel always prompts about the file format
 

Thanks thats great.

In case anyone else reading is interested, you can create the following
macro and assign it to Control - S (or somthing else) in order to seamlessly
remove the warnings.



Sub SaveNoPrompt()
'
' Macro1 Macro
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub