I don't know what "causes any how line-breaks" means.
Maybe this will help.
![]()
' semi-colon at end of Print to not add vbCrLf at end of print. Sub ArrayToFile() Dim F As Integer, s As String, a() As String, fn As String fn = "c:\temp\ArrayToFile.csv" s = "Kenneth,Ray,Hobson" s = Replace(s, ",", "|") a() = Split(s, "|") s = Join(a, vbCrLf) MsgBox s 'Save file F = FreeFile() Open fn For Output As F Print #F, s; Close F Shell "cmd /c Notepad c:\temp\ArrayToFile.csv" End Sub
Bookmarks