LoadText Method

See Also         Example         Applies To

Loads and parses the specified text file as a new range or spreadsheet.

Syntax

expression.LoadText(File, Delimiters, ConsecutiveDelimAsOne, TextQualifier)

expression   An expression that returns a Range or Spreadsheet object.

File   Required String. Specifies the name of the text file.

Delimiters   Optional String. Specifies the field delimiters.

ConsecutiveDelimAsOne   Optional Boolean. True to have consecutive delimiters considered as a single delimiter. The default value is False.

TextQualifier   Optional String. Specifies the text qualifier. The default value is the double quotation mark character.