Solved

VBA, New Line in Notepad

Posted on 2011-03-22
3
1,185 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 80

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
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 …

685 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