Skip to main content

TextStream object

Facilitates sequential access to file.

Syntax

TextStream. { property | method }

The property and method arguments can be any of the properties and methods associated with the TextStream object. Note that in actual usage, TextStream is replaced by a variable placeholder representing the TextStream object returned from the FileSystemObject.

Remarks

In the following code, a is the TextStream object returned by the CreateTextFile method on the FileSystemObject; WriteLine and Close are two methods of the TextStream object.

Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\testfile.txt", True)
a.WriteLine("This is a test.")
a.Close

Methods

Method Description
Close Closes an open TextStream file.
Read Reads a specified number of characters from a TextStream file and returns the result.
ReadAll Reads an entire TextStream file and returns the result.
ReadLine Reads one line from a TextStream file and returns the result.
Skip Skips a specified number of characters when reading a TextStream file.
SkipLine Skips the next line when reading a TextStream file.
Write Writes a specified text to a TextStream file.
WriteBlankLines Writes a specified number of new-line characters to a TextStream file.
WriteLine Writes a specified text and a new-line character to a TextStream file.

Properties

Property Description
AtEndOfLine Returns true if the file pointer is positioned immediately before the end-of-line marker in a TextStream file, and false if not.
AtEndOfStream Returns true if the file pointer is at the end of a TextStream file, and false if not.
Column Returns the column number of the current character position in an input stream.
Line Returns the current line number in a TextStream file.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>