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