Macro Sheets Only
Equivalent to using the Text Import Wizard to open a text file in Microsoft Excel.
Syntax
OPEN.TEXT(file_name, file_origin, start_row, file_type, text_qualifier, consecutive_delim, tab, semicolon, comma, space, other, other_char, {field_info1; field_info2;...})
File_name is the full pathname of the text file you want to open.
File_origin specifies the operating environment the text file was created in.
File_origin Operating system
1 Macintosh
2 Windows (ANSI)
3 MS DOS (PC-8)
omitted Current operating environment
Start_row is a number greater than or equal to one, specifying the row in the text file where you want to start importing into Microsoft Excel. This number should be less than the number of lines in the text file.
File_type specifies the type of delimited text file to import:
File_type Type of file
1 or omitted Delimited
2 Fixed Width
Text_qualifier indicates the character-enclosing text fields in the text file:
Text_qualifer value Qualifer
1 or " " (double quotation mark)
2 or ' ' (single quotation mark)
3 or {None} No text qualifier
Consecutive_delim is a logical value corresponding to the Treat Consecutive Delimiters as One check box which, if TRUE, allows consective delimiters (such as ",,,") to be treated as a single delimiter. If FALSE, all consecutive delimiters are considered separate column breaks.
Tab, semicolon, comma, space are logical values corresponding to the check boxes in the Column Delimiters group. If an argument is TRUE, the check box is selected. These arguments apply only when the file_type argument is 1 or omitted (delimited file type).
Other is a logical value indicating a custom delimiter to use in opening the text file.
Other_char specifies the custom delimiter to use or FALSE if no custom delimiter is used.
Field_info is an array which consists of the following elements: "column number, data_format", if file_type is 1; or "start_pos, data_format" if file_type is 2.
Related Functions
TEXT.TO.COLUMNS Parses text, as in a text file, into columns of data
List of Command-Equivalent Functions