QueryTable.TextFilePlatform Property

Syntax

expression.TextFilePlatform

expression A variable that represents a QueryTable object.

Remarks

The default value is the current setting of the File Origin option in the Text File Import Wizard.

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 imports an MS-DOS text file into the query table on the first worksheet in the first workbook, and then it refreshes the query table.

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 .TextFilePlatform = xlMSDOS .TextFileParseType = xlDelimited .TextFileTabDelimiter = True .Refresh End With

See also:

• QueryTable Object
• QueryTable Object Members