linking a cell to an exchange rate in a website

[tonylpcs@yahoo.co.uk]

hi everyone,

is there anyway i can add to say sheet1 cell A1 a link to an online exchange rate for euros? so i dont have to keep looking up the rate on line it just apears in the cell or some kind of box on my spreedsheet?

thanks

Tony

 

[Andrew Poulsom]

You may be able to use a web query. What's the URL?

 

[tonylpcs@yahoo.co.uk]

the one i use is

http://www.exchangerates.org.uk/Euro-EUR-currency-table.html

thanks

Tony

 

[Andrew Poulsom]

Have you tried a web query that returns only tables 1 or 2 or both?

 

[tonylpcs@yahoo.co.uk]

Erm?

sorry but im a bit of a novice!

Help?

mabe a formula or code with instructions on how to use it? please?

thanks

Tony

 

[Andrew Poulsom]

Select A1 on a new worksheet and choose Data|Get External Data|New Web Query from the menu. Type your URL in the address box, select Table 1 and click OK. Does that give you what you want?