This topic has not yet been rated - Rate this topic

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`

See Also

Excel Object Model Reference
QueryTable Object Members
QueryTable Object Events
Using Events with the QueryTable Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ