Importing data from the web

D

Darren

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

Darren O'Connell

Thanks for the response.

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

Cheers,
D
 
D

Don P

Darren,

Data / Import External Data /New Web Query

Type in the URL

Click the yellow arrow next to the rates

Click Import

Don Pistulka
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get External Data from Web 3
Importing several web pages with macro/VBA? 9
Capture Web Page Source Code 5
Trying to create a list of prices from a web page 1
How to extract data from a spreadsheet into a form/create form from spreadsheet data 3
Retrieving Exchange Rate Data from a Website 5
Converting amount($) of my expenditure into the base currency i wa 1
Selecting items from list and attaching ratios to selection 0

Top