Getting rid of warning re format?
 

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.

--
Terry, East Grinstead, UK

Getting rid of warning re format?
 

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.

--
Regards
Roger Govier

"Terry Pinnell" wrote in message
...
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.

--
Terry, East Grinstead, UK

Getting rid of warning re format?
 

"Roger Govier" <roger@technology4unospamdotcodotuk wrote:

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.

--
Terry, East Grinstead, UK