ADO SkipLine Method (Stream object)

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

ADO Stream object: SkipLine Method

SkipLine method skips all of the characters on one entire line, including the next line separator, while reading a text data Stream object.

The SkipLine method is used to skip over all characters up to and including the next line separator in a text data Stream object. If there is no line separator between the current position and EOS, the new current position simply becomes the EOS. By default, this method searches for an adCRLF line separator which is a carriage return/line feed.

You can use the LineSeparator property to set or return a LineSeparatorEnum value that specifies which binary character to use as the line separator in a text Stream object.

Syntax

objStream.SkipLine

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