| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel Worksheet As CSV - No Save As Dialog
I need to save an Excel worksheet as a CSV file using VBA without any prompts
or dialogs. Using the .SaveAs method, however, leads to a prompt: "Do you want to save the changes you made to filename.csv?" I don't get this prompt if I save the file as an .xls (due to SaveChanges=False / DisplayAlerts=False/...). Can this be done to csv files without resorting to OLE commands, etc.? Any help/suggestions greatly appreciated. SQLServant |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Excel Worksheet As CSV - No Save As Dialog
Found an answer a few seconds after posting this questions (don't u hate it
when that happens?)..... I used the .Saved=True method just before closing the newly created csv file. This stopped the prompt. SQLServant "SQLServant" wrote: I need to save an Excel worksheet as a CSV file using VBA without any prompts or dialogs. Using the .SaveAs method, however, leads to a prompt: "Do you want to save the changes you made to filename.csv?" I don't get this prompt if I save the file as an .xls (due to SaveChanges=False / DisplayAlerts=False/...). Can this be done to csv files without resorting to OLE commands, etc.? Any help/suggestions greatly appreciated. SQLServant |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save file dialog box in Excel | Excel Discussion (Misc queries) | |||
| Calling Excel File Save As Dialog | Excel Programming | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| How to not show save dialog after reading from excel file. | Excel Programming | |||
| Changing Save As Type in Save as dialog box | Excel Programming | |||
Linear Mode
