Programming Excel with VBA and .NET

QueryTable and QueryTables Members

Use the QueryTables collection to create new query tables and add them to a worksheet. Use the Worksheet object’s QuertyTables property to get a reference to this collection. Use the QueryTable object to refresh the data in the query table and to control other aspects of the query. The QueryTables and QueryTable objects have the following members . Key members (shown in bold) are covered in the following reference section:

Tip

Web query members are covered in Chapter 24.

1 Collection only
2 Object and collection
Add 1	AdjustColumnWidth
AfterRefresh	Application 2
BackgroundQuery	BeforeRefresh
CancelRefresh	CommandText
CommandType	Connection
Count 1	Creator 2
Delete	Destination
EditWebPage	EnableEditing
EnableRefresh	FetchedRowOverflow
FieldNames	FillAdjacentFormulas
Item 1	ListObject
MaintainConnection	Name
Parameters	Parent 2
PostText	PreserveColumnInfo
PreserveFormatting	QueryType
Recordset	Refresh
Refreshing	RefreshOnFileOpen
RefreshPeriod	RefreshStyle
ResetTimer	ResultRange
RobustConnect	RowNumbers
SaveAsODC	SaveData
SavePassword	SourceConnectionFile
SourceDataFile	TextFileColumnDataTypes
TextFileCommaDelimiter	TextFileConsecutiveDelimiter
TextFileDecimalSeparator	TextFileFixedColumnWidths
TextFileOtherDelimiter	TextFileParseType
TextFilePlatform	TextFilePromptOnRefresh ...