Retrieving Exchange Rate Data from a Website
 

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

Retrieving Exchange Rate Data from a Website
 

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

Retrieving Exchange Rate Data from a Website
 

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

--
steveB

Remove "AYN" from email to respond
"PS" wrote in message
...
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

Retrieving Exchange Rate Data from a Website
 

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" wrote:

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

--
steveB

Remove "AYN" from email to respond
"PS" wrote in message
...
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

Retrieving Exchange Rate Data from a Website
 

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

--
steveB

Remove "AYN" from email to respond
"PS" wrote in message
...
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" wrote:

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

--
steveB

Remove "AYN" from email to respond
"PS" wrote in message
...
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