Help importing data from a website into Excel?

[chaos]

Hi all,

From inside Excel, I wish to surf to a website and retrieve the bottom entry in a column The column updates dynamically with a new number added to the bottom on a daily basis.

Here is the website URL: http://global-view.com/fxhist.TXT.

The column I am interested in is the second column from the left under the History section. The column contains close prices for the currency symbol EUR/$.

I hope this is clear. Any help would be appreciated.

Regards,

chaos

 

[tlings]

Hi everyone. What if I needed a little more automation? I want text from the ENTIRE web page from 1,000 different URLs, each URL listed in Row A of a 1,000 different columns:

http://www.url1.com | http://www.url2.com | http://www.url3.com | etc...

Also, is there any way to keep all the text from each URL in one single column under the URL (so that it doesn't get pasted over the data in the other columns)? If not, I guess I could find a manual way around this myself...

Thanks so much!
TL