View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SimonW-UK
 
Posts: n/a
Default 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