| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| Macro to auto save file using the format YYMM | Excel Discussion (Misc queries) | |||
| Can't save new excel file | Excel Discussion (Misc queries) | |||
| When I save a file I consistently get a message about saving a co. | Excel Discussion (Misc queries) | |||
| Help... File Not Saved | Excel Discussion (Misc queries) | |||
Hybrid Mode
