QueryTable Object [Excel 2003 VBA Language Reference]

Multiple objects
QueryTable
Multiple objects

Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

Using the QueryTable Object

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.

Sheets("sheet1").QueryTables(1).FillAdjacentFormulas = True

Properties | AdjustColumnWidth Property | Application Property | BackgroundQuery Property | CommandText Property | CommandType Property | Connection Property | Creator Property | Destination Property | EditWebPage Property | EnableEditing Property | EnableRefresh Property | FetchedRowOverflow Property | FieldNames Property | FillAdjacentFormulas Property | ListObject Property | MaintainConnection Property | Name Property | Parameters Property | Parent Property | PostText Property | PreserveColumnInfo Property | PreserveFormatting Property | QueryType Property | Recordset Property | Refreshing Property | RefreshOnFileOpen Property | RefreshPeriod Property | RefreshStyle Property | ResultRange Property | RobustConnect Property | RowNumbers Property | SaveData Property | SavePassword Property | SourceConnectionFile Property | SourceDataFile Property | TextFileColumnDataTypes Property | TextFileCommaDelimiter Property | TextFileConsecutiveDelimiter Property | TextFileDecimalSeparator Property | TextFileFixedColumnWidths Property | TextFileOtherDelimiter Property | TextFileParseType Property | TextFilePlatform Property | TextFilePromptOnRefresh Property | TextFileSemicolonDelimiter Property | TextFileSpaceDelimiter Property | TextFileStartRow Property | TextFileTabDelimiter Property | TextFileTextQualifier Property | TextFileThousandsSeparator Property | TextFileTrailingMinusNumbers Property | TextFileVisualLayout Property | WebConsecutiveDelimitersAsOne Property | WebDisableDateRecognition Property | WebDisableRedirections Property | WebFormatting Property | WebPreFormattedTextToColumns Property | WebSelectionType Property | WebSingleBlockTextImport Property | WebTables Property

Methods | CancelRefresh Method | Delete Method | Refresh Method | ResetTimer Method | SaveAsODC Method

Events | AfterRefresh Event | BeforeRefresh Event

Parent Objects | ListObject Object | Range Collection

Child Objects | ListObject Object | Parameters Object | Range Object

See Also | QueryTable Object Events | Using Events with the QueryTable Object