| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file in a macro
I am using the following statement to save a file:
ActiveSheet.SaveAs FileName:="c:\imports\paycheck.CSV", FileFormat:=xlCSV, CreateBackup:=False If the file already exists I get prompted with the overwrite box...can I do something in the macro to automatically overwrite the existing file ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a file while recording a macro | Excel Discussion (Misc queries) | |||
| Saving a text file macro | Excel Discussion (Misc queries) | |||
| Macro Help for Saving a file | Excel Worksheet Functions | |||
| Saving an Excel file as a CSV using a Macro | Excel Programming | |||
| Saving a new file with a macro | Excel Programming | |||
Threaded Mode
