If you don't mind delayed quotes, I have a free open-source add-in
that might be of use. The add-in, documentation on its functions, and
sample templates can be found in the files area of this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

Some examples to get one or more quotes from Yahoo's current quotes
interface (array-entered functions):

=RCHGetYahooQuotes("USDJPY=X")
=RCHGetYahooQuotes("USDJPY=X","l1d1t1ba")
=RCHGetYahooQuotes("USDJPY=X,USDEUR=X","l1d1t1ba")
=RCHGetYahooQuotes(A1:A2,"l1d1t1ba")

On Jun 1, 1:02 am, wrote:
I'm building an Excel spreadsheet which requires input of foreign
currency exchange rates.

Rather than a user manually input or update an exchange rate, is there
some way of having the exchange rate automatically inserted into the
spreadsheet, for instance if the user is online with the spreadsheet
open, I'm wondering if perhaps some html code can be buried into a
spreadsheet cell which achieves desired result.

Any tips appreciated.