Currency Conversion Macro

LKnupp

New Member
Joined
Mar 29, 2011
Messages
3
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.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

LKnupp

New Member
Joined
Mar 29, 2011
Messages
3
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

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Mar 29, 2011
Messages
3
Thanks for that tip! I think that may be easier than creating a macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,358
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top