How to replace Carriage Return(CRLF) to Line Feed(LF) in text file from excel

[Goodstart14]

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.

[Kenneth Hobson]

Maybe something like this. In the Replace() line, use vbCRLF and vbLF. Change other parts such as the path and filename to suit.

Please Login or Register  to view this content.

[jindon]

Simply

Please Login or Register  to view this content.

[apo]

Maybe this too?

Change output path to suit..

Please Login or Register  to view this content.

[Goodstart14]

Thank you so much all!!