Currency Converter From Website
 

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/s...ymbol=%2FCADUS
I will need to grab the numeral value from it.

Thanks in advance.

Currency Converter From Website
 

Use the yahoo versionright click sheetexport to ms exceldataimport
external dataedit queryselect tablerefresh when needed and apply to your
needs
http://finance.yahoo.com/currency/co...submit=Convert

--
Don Guillett
SalesAid Software

"Erik" wrote in message
oups.com...
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/s...ymbol=%2FCADUS
I will need to grab the numeral value from it.

Thanks in advance.

Currency Converter From Website
 

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 :)

Currency Converter From Website
 

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

--
Don Guillett
SalesAid Software

"Erik Westlake" wrote in message
ups.com...
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 :)