Importing data from the web

[Darren]

Hi all,

I'm constructing a spreadsheet that is designed to list
currency rates for the day. I would like to source the
rates from a bank website.

I have been unable to locate any relevant information or
examples to help me achieve my goal. Any advice, pointers,
tips etc from this forum would be greatly appreciated.

 

[Don P]

Darren,

http://moneycentral.msn.com/investor/market/rates.asp

Don Pistulka

 

[Darren O'Connell]

Thanks for the response.

I have the source data but I need to know how to get this
information into my spreadsheet.

Cheers,
D

 

[Don P]

Darren,

Data / Import External Data /New Web Query

Type in the URL

Click the yellow arrow next to the rates

Click Import

Don Pistulka