pull of exchange rates via web query option

[Benjamin2008]

Dear All,

I need to set up a web query option on excel 2007 and download exchange rates automaticly rather then going on to website .

If i Change the date on (B6) i want B8,B9,B10 ) cell updated automaticly with relavant date's rates

Could anyone help
Thanks
Ben

[contaminated]

hi Bemjamin
I've actually seen many thing in excel done... but I think this one is not possible...
But anyway check these links

http://www.mrexcel.com/tip103.shtml
http://support.microsoft.com/kb/165499

HTH

[Benjamin2008]

Many thank you contaminated , you are a legend