Solved

I need help adding a line terminator in my VB6 application

Posted on 2014-01-09
1
289 Views
Last Modified: 2014-04-17
Hi Experts,
I am building a .csv file from an Array in my vb6 application.  The client has asked me to add a Line Terminator of Carriage Return, Line Feed (CRLF) to each row.  How can I do this?

Here is sample of how I create my rows of data as I loop through my Array:
 
strRecord = strRecord & "," & Trim$(Replace(tempRow.Extract(28, 1, 1), ",", "''"))


How do I add the CRLF terminator to this?  Thanks in Advance.
mrotor
0
Comment
Question by:mainrotor
1 Comment
 
LVL 10

Accepted Solution

by:
acbxyz earned 500 total points
Comment Utility
There is a special constant vbCRLF
strRecord = strRecord & "," & Trim$(Replace(tempRow.Extract(28, 1, 1), ",", "''")) & vbCRLF
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now