Currency Conversion Macro

[LKnupp]

Hello,

I'm trying to establish a dynamic currency conversion macro that would update my excel sheet with the current exchange rate. Is there an existing function that pulls this information? Is there a plug-in that I would be able to apply?

I appreciate all suggestions.

 

[John Davis]

Hello,

I'm trying to establish a dynamic currency conversion macro that would update my excel sheet with the current exchange rate. Is there an existing function that pulls this information? Is there a plug-in that I would be able to apply?

I appreciate all suggestions.

Would this be of any help?

http://www.webcontinuum.net/ws_4.aspx

 

[LKnupp]

That may be a good start. I'll be converting multiple currencies into USD within the same spreadsheet so I'm looking into the best way to handle each currency.

 

[Smitty]

Welcome to the Board!


If you go to Data-->From Web you can link to a webpage like http://www.x-rates.com/.


Once that's done you can set the refresh period or do it manually.


HTH,

 

[LKnupp]

Thanks for that tip! I think that may be easier than creating a macro.