Ozhatch
Board Regular
- Joined
- Oct 31, 2011
- Messages
- 65
- Office Version
- 2007
- Platform
- Windows
[TABLE="width: 100%"]
<tbody>[TR="class: uccRes"]
[TD="width: 47%"][/TD]
[TD="width: 6%"][/TD]
[TD="width: 47%, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
You guys have been very helpful in the past, and I hope you can help again.
I'm designing a tool that will assist our club treasurer to calculate member fees, and remittances from Australia to the organisation's headquarters in the USA. I would like to insert some sort of hyperlink which would interrogate a foreign exchange website and return a current exchange rate from Australian dollars to US dollars (or vice-versa).
The result of that interrogation, i.e. 1.00 USD = 0.998901 AUD would then become a factor in the spreadsheet, to do the conversion. (I took that conversion from XE: (USD/AUD) US Dollar to Australian Dollar Rate) Ideally, the 'fetch' should be in the background, and only the result would show in the spreadsheet.
Is this possible, and if so, how would it be done?
Waiting with bated breath...
<tbody>[TR="class: uccRes"]
[TD="width: 47%"][/TD]
[TD="width: 6%"][/TD]
[TD="width: 47%, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
You guys have been very helpful in the past, and I hope you can help again.
I'm designing a tool that will assist our club treasurer to calculate member fees, and remittances from Australia to the organisation's headquarters in the USA. I would like to insert some sort of hyperlink which would interrogate a foreign exchange website and return a current exchange rate from Australian dollars to US dollars (or vice-versa).
The result of that interrogation, i.e. 1.00 USD = 0.998901 AUD would then become a factor in the spreadsheet, to do the conversion. (I took that conversion from XE: (USD/AUD) US Dollar to Australian Dollar Rate) Ideally, the 'fetch' should be in the background, and only the result would show in the spreadsheet.
Is this possible, and if so, how would it be done?
Waiting with bated breath...