Copy selected table from web page using VBA

Question

i need to copy a particular table from a web page. So far i can open the web page using ie object.

when i use query table to copy the table from the web page, i didnt work.

when i view the html page i could find out that the required table is the second table in the web page

can anybody help me to copy the required table in to the worksheet

i found somewhere the following code:

Dim Doc As HTMLDocument Set Doc = IE.document

but i dont know how to proceed further

pls help...

Answer 1

Dear Don Guillett,

actuallu its our intranet, you would not get access. actually we need to login.. thats why i want to use IE object.

if i post the HTML code will you able to help?

Thanks for your response..

Answer 2

Dear Mike,

Thanks for your support, but i would like to automate the process with VBA, if you could suggest something in addition to this...

Answer 3

Can you post the url and the data you want. Perhaps an external query?

Answer 4

Hi,

Excel has the functionality to import tables from the web without any need for VB code. Select the cell that you want to be top-left of your data then

Data Tab|Get external data group|From Web

You now have a popup where you can paste the address of the web page and click 'GO' to navigate to that page. If you then scroll to the table you want you can select and import it.

Answer 5

Either the URL of the page or what you get when you use View / Source would be helpful.

Bernie