ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save Excel file to a CSV without opening it first (https://www.excelbanter.com/excel-programming/438065-save-excel-file-csv-without-opening-first.html)

Jodie

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


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com