ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing data from the web (https://www.excelbanter.com/excel-programming/271750-importing-data-web.html)

Darren[_3_]

Importing data from the web
 
Hi all,

I'm constructing a spreadsheet that is designed to list
currency rates for the day. I would like to source the
rates from a bank website.

I have been unable to locate any relevant information or
examples to help me achieve my goal. Any advice, pointers,
tips etc from this forum would be greatly appreciated.

Don P

Importing data from the web
 
Darren,

http://moneycentral.msn.com/investor/market/rates.asp

Don Pistulka

"Darren" wrote in message
...
Hi all,

I'm constructing a spreadsheet that is designed to list
currency rates for the day. I would like to source the
rates from a bank website.

I have been unable to locate any relevant information or
examples to help me achieve my goal. Any advice, pointers,
tips etc from this forum would be greatly appreciated.




Darren O'Connell

Importing data from the web
 
Thanks for the response.

I have the source data but I need to know how to get this
information into my spreadsheet.

Cheers,
D

-----Original Message-----
Darren,

http://moneycentral.msn.com/investor/market/rates.asp

Don Pistulka

"Darren" wrote in message
...
Hi all,

I'm constructing a spreadsheet that is designed to list
currency rates for the day. I would like to source the
rates from a bank website.

I have been unable to locate any relevant information or
examples to help me achieve my goal. Any advice,

pointers,
tips etc from this forum would be greatly appreciated.



.


Don P

Importing data from the web
 
Darren,

Data / Import External Data /New Web Query

Type in the URL

Click the yellow arrow next to the rates

Click Import

Don Pistulka

"Darren O'Connell" wrote in message
...
Thanks for the response.

I have the source data but I need to know how to get this
information into my spreadsheet.

Cheers,
D

-----Original Message-----
Darren,

http://moneycentral.msn.com/investor/market/rates.asp

Don Pistulka

"Darren" wrote in message
...
Hi all,

I'm constructing a spreadsheet that is designed to list
currency rates for the day. I would like to source the
rates from a bank website.

I have been unable to locate any relevant information or
examples to help me achieve my goal. Any advice,

pointers,
tips etc from this forum would be greatly appreciated.



.





All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com