Solved

VBA, New Line in Notepad

Posted on 2011-03-22
3
1,136 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:New_Alex
3 Comments
 
LVL 33

Accepted Solution

by:
it_saige earned 500 total points
ID: 35189807
Have you tried using:

VbCrLf, Chr(13) + Chr(10)

or

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

-saige-
0
 
LVL 79

Expert Comment

by:David Johnson, CD, MVP
ID: 35190298
windows uses cr ascii 13 + lf ascii 10
unix uses just lf ascii 10

maybe this page will be of assistance
0
 
LVL 1

Author Comment

by:New_Alex
ID: 35196147
VbCrLf made the trick, THANKS
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question