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

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