QueryTable.TextFileTextQualifier Property

Syntax

expression.TextFileTextQualifier

expression A variable that represents a QueryTable object.

Remarks

XlTextQualifier can be one of these XlTextQualifier constants.

xlTextQualifierNone

xlTextQualifierDoubleQuote default

xlTextQualifierSingleQuote

Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport).

Example

This example sets the single quotation mark character as the text qualifier for the query table on the first worksheet in the first workbook.

Visual Basic for Applications

Visual Basic for Applications
`Set shFirstQtr = Workbooks(1).Worksheets(1) Set qtQtrResults = shFirstQtr.QueryTables _ .Add(Connection := "TEXT;C:\My Documents\19980331.txt", _ Destination := shFirstQtr.Cells(1,1)) With qtQtrResults .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierSingleQuote .Refresh End With`

Set shFirstQtr = Workbooks(1).Worksheets(1) Set qtQtrResults = shFirstQtr.QueryTables _ .Add(Connection := "TEXT;C:\My Documents\19980331.txt", _ Destination := shFirstQtr.Cells(1,1)) With qtQtrResults .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierSingleQuote .Refresh End With

text file text qualifier textfiletext textfiletextqualifier textfiletextqualifier property

QueryTable.TextFileTextQualifier Property

Returns or sets the text qualifier when you import a text file into a query table. The text qualifier specifies that the enclosed data is in text format. Read/write XlTextQualifier.

See also: