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