VBA, New Line in Notepad

Hi

When exporting a string to a .txt file Using chr(13) or VbCr does not work. It displays a litle square instead of new line.

Any ideas?
LVL 1
New_AlexAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
it_saigeConnect With a Mentor DeveloperCommented:
Have you tried using:

VbCrLf, Chr(13) + Chr(10)

or

VbNewLine, Chr(13) + Chr(10) + Chr(13)

-saige-
0
 
David Johnson, CD, MVPOwnerCommented:
windows uses cr ascii 13 + lf ascii 10
unix uses just lf ascii 10

maybe this page will be of assistance
0
 
New_AlexAuthor Commented:
VbCrLf made the trick, THANKS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.