| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save .csv with overwrite
I need to modify a .csv file and save it via macro,
without prompting the user about whether to overwrite or not. I can't find anything in the save method for this, and overwrite appears to be limited to the copy function. How do I do this? Thanks in advance, Kevin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save .csv with overwrite
This will save your active book as a csv file
Application.DisplayAlerts = False ActiveWorkbook.SaveAs FileName:= _ "D:\My Documents\Book1.csv", FileFormat:= _ xlCSV, CreateBackup:=False Application.DisplayAlerts = Tru -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As / Overwrite | Excel Discussion (Misc queries) | |||
| Excel 2003, how do I save without having to say overwrite? | Excel Discussion (Misc queries) | |||
| How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
| Save a Copy/Overwrite changes dialog box | Excel Worksheet Functions | |||
| Save As without overwrite prompt | Excel Programming | |||
Linear Mode
