Specifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.

Version Information
Version Added: Excel

Name Value Description
xlAllTables 2 All tables
xlEntirePage 1 Entire page
xlSpecifiedTables 3 Specified tables