Getting rid of warning re format?

[Terry Pinnell]

In Excel 2000, is there some setting I've not yet found that will
prevent messages like this appearing every time I try to save a file
please?

"xyz.csv may contain features that are not compatible with CSV (Comma
delimited). Do you want to keep the workbook in this format?"

And can I (temporarily) avoid the message asking I want to over-write
a file? During a long series of small changes that gets tiresome.

 

[Roger Govier]

Hi Terry

You can only do it using a macro, where you set

Application.DisplayAlerts = False

run the rest of your code

Application.DisplayAlerts = True

The default is to be True, and you cannot just switch it off with a macro,
as it defaults back to True as soon as the macro ends.
Equally, trying to set it from the immediate window of the VB Editor will
not set it to false.

 

[Terry Pinnell]

Hi Terry

You can only do it using a macro, where you set

Application.DisplayAlerts = False

run the rest of your code

Application.DisplayAlerts = True

The default is to be True, and you cannot just switch it off with a macro,
as it defaults back to True as soon as the macro ends.
Equally, trying to set it from the immediate window of the VB Editor will
not set it to false.

Thanks Roger. That's disappointing - I'd hoped there was a simple
user-setting in Options I'd missed! Seems a design flaw IMO.