ADO Stream Object: WriteText Method

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

ADO Stream object: WriteText Method

The Write method is used to write a text to a text Stream object.

If there is data in the Stream object and the current position is EOS, the new data will be appended beyond the existing data. If the current position is not EOS, the existing data will be overwritten.

If you write past EOS, the size of the Stream will increase. EOS will be set to the last character in the Stream. If you don't write past EOS, the current position will be set to the next character after the newly added data. Previously existing data will not be truncated. Call the SetEOS method to truncate. 

Note: This method is used only with text Stream objects, for binary Stream objects, use the Write method.

Syntax

objStream.WriteText data,options

Example


objStream.Position = 0
objStream.WriteText strMyText
If (objStream.Position < objStream.EOS) Then
   objStream.SetEOS = objStream.Position
End If

 


 
Parameter

Description

data Required. The text to be written to a text Stream object
options Optional. A StreamWriteEnum value that specifies whether a line separator must be added to the text

StreamWriteEnum Value

Constant Value

Description

adWriteChar 0 Default. Writes the specified text to a Stream object
adWriteLine 1 Writes the specified text and a line separator to a Stream object. If the LineSeparator property is not defined, a run-time error will occur