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