O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required