Retrieving Exchange Rate Data from a Website

[Guest]

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/market/crncconverter.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

 

[STEVE BELL]

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 (e-mail address removed))

 

[Guest]

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]

Patricia,

You are looking for a method to automatically retrieve data from the net.

Open Excel
Open a new workbook
go to the Data menu
select Get External Data
select New Web Query
and see if this will work for you.

I once did this a long time ago and built a macro to retrieve stock quotes.

Go to the below site and download the Google Search add-in.
This is a great way to search for excel solutions...

http://www.rondebruin.nl/Google.htm

let me know if any of this helps...

 

[Guest]

Hi, Steve;
I tried as you requested. The import method only gave me the text prompts,
"Convert this Amount", "From" and "To", but no automation as shown on the
website. Is there more I should do to get it to work? I installed the
Add-in as well and the search brought me pretty much the same results as all
the reading I did prior to posting my question here.

Any further information/guidance will be appreciated.

Thanks again.

Patricia

 

[STEVE BELL]

Patricia,

Retrieving data from the internet is not my forte.

Suggest you repost, but change your subject to something like -
How do I Import data from the Internet.

Than a brief explanation.

Sounds like you are trying to download (or import) a single value from a web
site and put it into a single cell on your worksheet.

If that is correct - than post that...

Sorry I couldn't be of more help.

But hang on to that add-in, it can really prove valuable.
And check out some of the sites listed on the bottom portion of the window.

keep on Exceling...