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.