I have been trying to prepare either *.txt or *.csv files from Julia to be read by a VBA script. It appears that the files prepared by Julia NOT PUT a carriage return(CR) line feed(LF) at the end of each line. It seems VBA detects and end of file (EOF) upon the first line feed (see VBA script below)…

Writing CSV or TXT files to be read by VBA script (not just opened by excel)

sijo January 24, 2021, 7:46am 2

CSV.write has a newline parameter: Home · CSV.jl

Can you try with CSV.write("input_VBA.csv", df, delim=',', decimal='.', newline="\r\n")?

1 Like

Topic		Replies	Views
How do i get CR+LF ('\r\n') line endings using CSV.jl? New to Julia	2	999	February 12, 2019
Reading text or csv files and assigning values to variable names New to Julia question	24	6053	November 25, 2020
How to export a column vector to text file with writedlm function General Usage	8	5008	April 19, 2020
[Solved] CSV.write(), file opens correctly in excel, but wrong layout in text General Usage	2	442	February 27, 2021
Saving using DelimitedFiled with header New to Julia question	2	386	May 5, 2020