Currency Conversion Macro

J

John Davis

Well-known Member

Joined

Sep 11, 2007

Messages

3,457

• Mar 30, 2011

• #2

LKnupp said:

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.

Click to expand...

Would this be of any help?

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

 

Upvote 0

L

LKnupp

New Member

Joined

Mar 29, 2011

Messages

3

• Mar 30, 2011

• #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.

 

Upvote 0

Smitty

Legend

Joined

May 15, 2003

Messages

29,536

• Mar 30, 2011

• #4

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,

 

Upvote 0

L

LKnupp

New Member

Joined

Mar 29, 2011

Messages

3

• Mar 30, 2011

• #5

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

 

Upvote 0