ExcelBanter - how do I stop warnings when saving .xls as csv?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I stop warnings when saving .xls as csv? (https://www.excelbanter.com/excel-discussion-misc-queries/1772-how-do-i-stop-warnings-when-saving-xls-csv.html)

leeandhazel

how do I stop warnings when saving .xls as csv?

I want to save an Excel file as a csv file on a reasonable regular basis can
I turn the warnings as I seem to be saving twice at least during the close
operation.

Frank Kabel

Hi
in VBA you could use
application.displayalerts=false
'your save code
application.displayalerts=true

"leeandhazel" wrote:

I want to save an Excel file as a csv file on a reasonable regular basis can
I turn the warnings as I seem to be saving twice at least during the close
operation.

All times are GMT +1. The time now is 05:48 PM.