CommandText Property Example

This example sets the command string for the first query table’s ODBC data source. Note that the command string is an SQL statement.

Set qtQtrResults = _
    Workbooks(1).Worksheets(1).QueryTables(1)
With qtQtrResults
    .CommandType = xlCmdSQL
    .CommandText = _
        "Select ProductID From Products Where ProductID < 10"
    .Refresh
End With