Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 279
Default Copying table from webpage to worksheet

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stopping copying from a webpage Tadhg Excel Discussion (Misc queries) 1 June 28th 06 07:09 PM
Saving worksheet as webpage Aramis Excel Discussion (Misc queries) 1 January 9th 06 10:26 PM
How can I link to a specific worksheet from a webpage? RMF Excel Discussion (Misc queries) 1 September 7th 05 01:10 PM
Application to turn a table layout webpage back into a spreadsheet? Jamie Furlong Excel Discussion (Misc queries) 3 August 12th 05 09:40 PM
Copying from excel sheet on IE webpage AH Excel Programming 0 February 2nd 04 06:31 PM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"