LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 72
Default Currency automation

I'm having Numaric values in a range from X18:BI52. I wanted to put a
dropdown box (Form Combo box) to select currency
symbols(USD,HKD,GBP,CNY,INR). By default all values in the range according to
USD, the moment when I select other currencies from the list then the values
in the range should automatically calculate according to exchange rates which
links to website, consists of exchange rates (suggest best link).

Let say bydefault "USD".
If I select "HKD", exchange rate from USD TO HKD.
Later if I select "CNY", exchange rate from HKD TO CNY.
Later if I select "GBP", exchange rate from CNY TO GBP.

So, the exchange rate values should reflect with the existed values in the
range.
In otherwards, bydefault "USD" seleted.
(In the range X18:BI52)
X18=1.00
X19=2.00
Z24=3.00

If I select "INR" (Assume that $ 1.00 = INR 40.00)
(In the range X18:BI52)
X18=40.00
X19=80.00
Z24=120.00

So, when ever i selected currency then it should automatically get the
exchange rate value from the website and do calculation and replace the
existed values in the range. And also suggest me the best site for exchange
rates to link with this sheet.

Note: without VBA code.

Any one help me out from this problem.

Advanced Thanks,
Vinod
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Allenc Excel Worksheet Functions 5 January 13th 07 10:42 AM
printing automation wsk Excel Discussion (Misc queries) 0 May 17th 06 02:18 PM
Automation Error xlEnt Excel Discussion (Misc queries) 2 May 15th 06 11:37 PM
Automation?? Help in automation Excel Discussion (Misc queries) 1 April 12th 06 02:10 PM
automation Darius New Users to Excel 1 September 23rd 05 07:37 AM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"