Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tables from web to excel
I am able to navigate to a webpage, but wish to copy only one table from the
page - table(2). How do i get it from the webpage to excel? I know that the code below will make xTable the 2nd table, but how do i get the table to appear in excel instead of [object] Dim oResultPage As HTMLDocument Dim AllTables As IHTMLElementCollection Dim xTable As IHTMLTable Set oResultPage = ie.Document Set AllTables = oResultPage.getElementsByTagName("table") Set xTable = AllTables.Item(2) thanks George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate tables into html tables | Excel Discussion (Misc queries) | |||
concatenate tables into html tables | New Users to Excel | |||
Opening Excel 03 files in Excel 07 Pivot tables & graph not workin | Excel Discussion (Misc queries) | |||
Pivot4U Excel Add-in - Edit Pivot Tables in Excel Directly | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) |