| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel file to a CSV without opening it first
I have an Excel file that is too large to open in Excel. I need to save it
as a csv file so I can use it in an import. How would I write a macro to save this file? This is what I have, but it tries to open the file before saving: Sub ChangetoCsv() ActiveWorkbook.SaveAs Filename:= _ "H:\_YEAR_END_REPORTS\DOWNLOAD_FILES\ORIGINALS\200 9\" & "account numbers" & ".csv" _ , FileFormat:=xlCSV, CreateBackup:=False End Sub -- Thank you, Jodie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Opening Reuters, Opening Excel File, Closing Excel File | Excel Programming | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| 'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Excel marcos firing on file save as but not file save | Excel Programming | |||
Linear Mode
