QueryTable object (Excel)
Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database.
The QueryTable object is a member of the QueryTables collection.
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
- AdjustColumnWidth
- Application
- BackgroundQuery
- CommandText
- CommandType
- Connection
- Creator
- Destination
- EditWebPage
- EnableEditing
- EnableRefresh
- FetchedRowOverflow
- FieldNames
- FillAdjacentFormulas
- ListObject
- MaintainConnection
- Name
- Parameters
- Parent
- PostText
- PreserveColumnInfo
- PreserveFormatting
- QueryType
- Recordset
- Refreshing
- RefreshOnFileOpen
- RefreshPeriod
- RefreshStyle
- ResultRange
- RobustConnect
- RowNumbers
- SaveData
- SavePassword
- Sort
- SourceConnectionFile
- SourceDataFile
- TextFileColumnDataTypes
- TextFileCommaDelimiter
- TextFileConsecutiveDelimiter
- TextFileDecimalSeparator
- TextFileFixedColumnWidths
- TextFileOtherDelimiter
- TextFileParseType
- TextFilePlatform
- TextFilePromptOnRefresh
- TextFileSemicolonDelimiter
- TextFileSpaceDelimiter
- TextFileStartRow
- TextFileTabDelimiter
- TextFileTextQualifier
- TextFileThousandsSeparator
- TextFileTrailingMinusNumbers
- TextFileVisualLayout
- WebConsecutiveDelimitersAsOne
- WebDisableDateRecognition
- WebDisableRedirections
- WebFormatting
- WebPreFormattedTextToColumns
- WebSelectionType
- WebSingleBlockTextImport
- WebTables
- WorkbookConnection
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.