ADO Stream Object: LineSeparator Property

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

ADO Stream Object: LineSeparator Property

The LineSeparator property sets or returns a LineSeparatorsEnum value that indicates the line separator character used in a text Stream object. Default is adCRLF.

Syntax 

objStream.LineSeparator

The three choices are carriage return, line feed, or the default which is both a carriage return and a line feed.
 
LineSeparatorEnum Constants

Constant Value

Description
adCR 13 Carriage return only
adCRLF -1 Default, both a carriage return and a line feed
adLF 10 Line feed only

 

Example 


objStream.LineSeparator = adLF