QueryTable and QueryTables Web Query Members

Query tables are general-purpose objects that import data from a variety of sources including text files and databases. Many of the QueryTable object members apply only to those data sources, and not to web queries. Therefore, the members covered in this section (shown in bold) are specific to web queries:

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

HasAutoFormat

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

Sql

TablesOnlyFromHTML

TextFileColumnDataTypes

TextFileCommaDelimiter

TextFileConsecutiveDelimiter

TextFileDecimalSeparator

TextFileFixedColumnWidths

TextFileOtherDelimiter

TextFileParseType

TextFilePlatform

TextFilePromptOnRefresh

TextFileSemicolonDelimiter

TextFileSpaceDelimiter ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial