Hello, Steve,

Thank you for responding to my Excel/VBA question. Sorry for the delay in
getting back to you.

Right now, we have a worksheet that has columns of information where Col1 =
Foreign $ figure, Col2 = Exchange Rate, Col3 = US $ (based on conversion of
Col1). The user must enter the Foreign $ amount, then go online and retrieve
the exchange rate and enter that in Col2 before Col3 will calculate. I would
like to simplify this process, perhaps eliminate what steps I can and write
the code to automatically retrieve the Exchange Rate from the MSN Money
Central website, perform the conversion and list the amount in US $ in a
separate cell. If you can offer a better suggestion, I be open to changing
my method.


If you need more information than what I've provided herein, please let me
know. Thanks.

Patricia


"STEVE BELL" wrote:

Patricia,

Sorry no one has answered you, yet...

What you ask is easily done in Excel and can be done in many different ways.

Post back with more about how you want it to work.

(You can write me direct at )

--
steveB

Remove "AYN" from email to respond
"PS" wrote in message
...
Please bear with me. I am such a beginner user of VBA, I can be
considered a
pre-user!
I would like to retrieve the daily exchange rates for a particular
currency,
convert it into US dollars and insert it into my worksheet. We typically
use
http://moneycentral.msn.com/investor...cconverter.asp.
Can I automate this process so the user is prompted to enter the $ amount,
'currency from' and 'currency to', without having to leave the worksheet?
Any help would be appreciated and bear in mind my knowledge is elementary
at
best.
Thanks
Patricia