CSV Unicode text file convert to CSV MS-DOS with VBA

[Enna]

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 you

 

[Fluff]

Duplicate to: Convert CSV Unicode Text type to CSV MS-DOS type

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.