Application.ImportTextFree

Function Application.ImportTextFree( _
    fileName As String, _
    NbVars As Long, _
    NbCases As Long, _
    Optional formatStatement As String = "", _
    Optional separators As String = ",; \t\r\n", _
    Optional bTreatMultipleSeparatorsAsMissingData As Boolean = False, _
    Optional bUseQuotationMarksAsTextBoundaries As Boolean = False, _
    Optional bCaseNamesFromFirstColumn As Boolean = False) As Spreadsheet

• fileName [in]

The fully-qualified pathway to the text file to import.

Type: String

• NbVars [in]

How many variables to import.

Type: Long

• NbCases [in]

How many cases to import.

Type: Long

• formatStatement [in,optional]

The format to apply when importing.

Type: String

Default value: ""

• separators [in,optional]

The character that will be interpreted as separators. This parameter defaults to ",;\t\r\n ".

Type: String

Default value: ",; \t\r\n"

• bTreatMultipleSeparatorsAsMissingData [in,optional]

Whether or not to treat multiple separators as missing data. This parameter defaults to False.

Type: Boolean

Default value: False

• bUseQuotationMarksAsTextBoundaries [in,optional]

Whether or not to use quotation marks as text boundaries. This parameter defaults to False.

Type: Boolean

Default value: False

• bCaseNamesFromFirstColumn [in,optional]

Whether or not to import the first column in the text file as the case names. This parameter defaults to False.

Type: Boolean

Default value: False