extract data from webpage

hi all,

I am new to microsoft excel and also in this forum. I've got some problems with extracting data in excel.
What I want to know is that is it possible to extract data from webpage and autodelete some columns when I open the excel file?Also, the webpage is dyanmic one. So I want to make it refresh data according to the webpage.
How can I make it? Also I'd like to know is it possible in excel or not.
Can anyone help me with it ?
Thanks in advance.

Hello WinteE,

I am the same person with zzseason.I just opened new account because there is problem in opening my old account.
Anyway, thanks alot for helping me so far.
Can you help explain a bit more details how to do for it? I am totally new to it.
I have tried to import data using 'new web query' as you said. But the message says, return no data and can't see anything.
So how should I do for it?
By the way, I am using excel 2000.
thanks.

hi,
thanks for helping so far.
yea, it works well with the page you gave.
But I still have problems when I use this way to extract data from the page I want.
Do you think is it possible to use this way if the data I want to extract is not tabular format?
It's not inside <table> and </table> in html page.
thanks in advance for further help also.