Syntax

expression.TextFileSemicolonDelimiter

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 property set to xlTextImport).

Example

This example sets the semicolon to be the delimiter in the query table on the first worksheet in the first workbook and then refreshes the query table.

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 .TextFileSemicolonDelimiter = True .Refresh End With
text text file semicolon delimiter Text File Semicolon Delimiter Property textfile textfilesemicolon TextFileSemicolonDelimiter TextFileSemicolonDelimiter Property

See also: