Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

QueryTable Object

Office 2007
Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database.

Remarks

The QueryTable object is a member of the QueryTables collection.

Example

Use QueryTables(

index), where index is the index number of the query table, to return a single QueryTable object. The following example sets query table one so that formulas to the right of it are automatically updated whenever it’s refreshed.
Visual Basic for Applications
Sheets("sheet1").QueryTables(1).FillAdjacentFormulas = True



Community Additions

Show:
© 2015 Microsoft