XlQueryType can be one of these XlQueryType constants. |
xlTextImport. Based on a text file, for query tables only |
xlOLEDBQuery. Based on an OLE DB query, including OLAP data sources |
xlWebQuery. Based on a Web page, for query tables only |
xlADORecordset. Based on an ADO recordset query |
xlDAORecordSet. Based on a DAO recordset query, for query tables only |
xlODBCQuery. Based on an ODBC data source |
expression.QueryType
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
You specify the data source in the prefix for the Connection property’s value.
Example
This example refreshes the first query table on the first worksheet if the table is based on a Web page.
Set qtQtrResults = _
Workbooks(1).Worksheets(1).QueryTables(1)
With qtQtrResults
if .QueryType = xlWebQuery Then
.Refresh
End If
End With