pasting a web page onto a worksheet

[tessie]

Is it possible to write code to copy & paste a web page to a wor
sheet?

I currently have a hyperlink on a worksheet that I can manually click
a new ie window appears, I copy a table, close the window, & paste th
table into a range on a worksheet.

I would like to automate this entire process with a macro/vb.

If I could simply paste the entire web page, I think I could write th
code to delete every thing but the table I need.

I recorded a macro to 'follow' the hyperlink but I don't know how t
write the code to 'select all' & 'Copy' anything in the web page.

Thanks

Tessi