Currency Converter From Website

[Erik]

I am looking to create a Currency converter to pull from a live website
so when I make a workbook I can use this macro to convert it to USD or
other currencies of my choice.

Anyone have any thoughts?

The site I will be pulling from is :
http://moneycentral.msn.com/detail/stock_quote?Symbol=/CADUS
I will need to grab the numeral value from it.

Thanks in advance.

 

[Don Guillett]

Use the yahoo version>right click sheet>export to ms excel>data>import
external data>edit query>select table>refresh when needed and apply to your
needs
http://finance.yahoo.com/currency/convert?amt=1&from=CAD&to=USD&submit=Convert

 

[Erik Westlake]

Thanks for thefast response. I got this completed using xe.com
already. I prefer that site because it has all units not just USD to
CAD and its reverse

 

[Don Guillett]

then you could have used.
http://finance.yahoo.com/currency