Does any one know how to save an Excel .csv file from within VB. I can open the .csv file and modify it, but when I try to do save it with the following command I get an error 1004 and the program crashes. (xlApp is the object created for MS Excel)
xlApp.ActiveWorkbook.Close filename:=Path & theCSVname, FileFormat:=xlCSV, CreateBackup:=False
Any help would be greatly appreciated.
