Copying table from webpage to worksheet

Good morning!

I want to create a macro that opens the following hyperlink:
http://www.nordpool.no/marketinfo/el...s/overview.cgi

than selects the table on this webpage and copies it to my worksheet.

How can this be done?

Thanks in advance for any help!

Excel 2003

Data > Import External DATA > New Web Query

opens a browser
put your URL in and hit Go
select which tables you want

data shows up on the current sheet

"gerok" wrote:

>
> Good morning!
>
> I want to create a macro that opens the following hyperlink:
> http://www.nordpool.no/marketinfo/el...s/overview.cgi
>
> than selects the table on this webpage and copies it to my worksheet.
>
> How can this be done?
>
> Thanks in advance for any help!
>
>
> --
> gerok
> ------------------------------------------------------------------------
> gerok's Profile: http://www.excelforum.com/member.php...fo&userid=6637
> View this thread: http://www.excelforum.com/showthread...hreadid=477066
>
>