Hi,
I exported one sheet in my workbook as text file(Tab deliminated).
When I opened the text file in Note pad++, I saw CRLF, every row.
I'd like to replace this 'CRLF' to 'LF'.
How can I do that?


Dim NewWb As Workbook
Dim fname As Variant

fname = "C:\\"
NewWb.SaveAs fname _
, FileFormat:=xlText, CreateBackup:=False
New.Close False

Before closing NewWb, can I open the txt.file and replace it?

Thanks in advance.