I have 4 small and bigger csv files. I would like to change file type from "csv unicode text" to "csv ms-dos". Some files are very large, so when I open and use "save as" it would truncate the data (as excel max reaches about 1047000 rows but I have over 1900000 rows). I can open the smaller file and use a VBA converter to apply for all 4 files. How can i do that? Thank youIf you don't know how to write VBA code, then I do not think that VBA is a viable solution for you unless someone volunteers to create the code for you. I wish you well, but unfortunately I do not have the time to spend on that effort.