QueryTable.TextFileStartRow Property

Syntax

expression.TextFileStartRow

expression A variable that represents a QueryTable object.

Remarks

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 row 5 as the starting row for text parsing in the query table on the first worksheet in the first workbook, and then it refreshes the query table.

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 .TextFileStartRow = 5 .TextFileTabDelimiter = True .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 .TextFileStartRow = 5 .TextFileTabDelimiter = True .Refresh End With

text file start row Text File Start Row Property textfilestart TextFileStartRow TextFileStartRow Property

Returns or sets the row number at which text parsing will begin when you import a text file into a query table. Valid values are integers from 1 through 32767. The default value is 1. Read/write Long.

See also: