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
|