Here is a site that allowed me to make an external query
http://www.xe.com/ucc/convert.cgi?Am...8&im age.y=14

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Louise01" wrote in message
...
I am trying to import into a spreadsheet a link that will provide the daily
US dollar which automatically calculates into AUS dollars so the numbers
will
change each time the spreadsheet is opened with the correct daily amount.
Can anyone help me with this.

Thanks
--
Louise