QueryTable Object
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(), where is the index number of the query table, to return a single QueryTableobject. 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 |
|---|
|
See also:
- Excel Object Model Reference
- QueryTable Object Members
- QueryTable Object Events
- Using Events with the QueryTable Object
| index | index |