Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When saving CSV excel always prompts about the file format
I work with a lot of csv files all day and they have to be this format for
other applications and scripts to use them. Everytime I save Excel prompts "filename.csv may contain features that are not compatible with csv, do you want to keep this format". This is the case even with Control S. The only formating is that I make the columns big enough for me to read whats in each cell. Anyway - can I turn off this prompt so that Excel just saves the file as csv? Thanks, Simon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When saving CSV excel always prompts about the file format
Try this before the save
Application.DisplayAlerts = False and reset it after the save Application.DisplayAlerts = True -- Regards Ron de Bruin http://www.rondebruin.nl "SimonW-UK" wrote in message ... I work with a lot of csv files all day and they have to be this format for other applications and scripts to use them. Everytime I save Excel prompts "filename.csv may contain features that are not compatible with csv, do you want to keep this format". This is the case even with Control S. The only formating is that I make the columns big enough for me to read whats in each cell. Anyway - can I turn off this prompt so that Excel just saves the file as csv? Thanks, Simon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
When saving CSV excel always prompts about the file format
Thanks thats great.
In case anyone else reading is interested, you can create the following macro and assign it to Control - S (or somthing else) in order to seamlessly remove the warnings. Sub SaveNoPrompt() ' ' Macro1 Macro Application.DisplayAlerts = False ActiveWorkbook.Save Application.DisplayAlerts = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
how do i disable warning when saving file in csv format? | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) |