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