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

L

leeandhazel

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.
 
F

Frank Kabel

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