Hi,

Here's one way:

Select any cell then go to Data/Get external data/New web query, in the text
box type: http://www.x-rates.com/ click OK, select New worksheet in the popup
window, click on Properties, under Refresh Control select "refresh every" and
"refresh data on file open" ,set the amount of minutes interval you wish the
data to refresh and click OK OK. I think euro to pound rates are in F18 but
you can check the net to make sure!

HTH
Jean-Guy

"Roger on Excel" wrote:

I have a spreadsheet i use to convert pound sterling to euro's.

I want the spreadsheet to automatically access the current exchange rate
from the internet for pound into euros so that i can push a button that would
update a cell with the current value

Can anyone help