Edit

TextStream object

  • Article

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.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.