Disable exceptions thrown on File Save As
 

I am working on a long term project where I am creating thousands of csv
files from Excel using the File Save As menu item. Every time one does this
they get two messages: File type doesn't support multiple pages and
Myfile.csv may contain features that ...

It is totally madening and over the months its wasting a lot of time. How
can I disable the throwing of these exceptions?




--
mark b

Disable exceptions thrown on File Save As
 

If you're using a macro, just put:
Application.DisplayAlerts = False
before the line using .SaveAS... and:
Application.DisplayAlerts = True after it...

If you don't use any macro, you can try using the event BeforeSave of the
workbook and testing the SaveAsUI parametre...
But if you don't want to use any macros, I can't see how to disable the
alerts!
---
KR,

V.


"mark" wrote:

I am working on a long term project where I am creating thousands of csv
files from Excel using the File Save As menu item. Every time one does this
they get two messages: File type doesn't support multiple pages and
Myfile.csv may contain features that ...

It is totally madening and over the months its wasting a lot of time. How
can I disable the throwing of these exceptions?




--
mark b