Monday, December 22, 2014

Save Current Excel Workbook To A CSV Format File

Following code can be used to save the current work book into CSV format to the folder fullPATH and ignore the backup.

ActiveWorkbook.SaveAs Filename:= _
        "fullPATH\fileName.csv", FileFormat:= _
        xlCSV, CreateBackup:=False

No comments: