How to load data into excel?

  • Thread starter Thread starter Eric
  • Start date Start date
Have you tried Data/Import External Data/New Web Query.

You supply the URL and then select the tables from the web page you want to
import.
 
When I load following link, it requests for open / save cvs file.
Do you have any suggestions on how to load it without opening or saving any
file?
Thank you very much for any suggestions
Eric
 
That link is to a *.csv file. not a data table.

You must find an alternate link to get to the source data for the quote.csv
file.


Gord Dibben MS Excel MVP
 

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

VBA Workbooks.Open() / method 'open' of object 'workbooks' failed 0
accessing data on the web 5
Parsing Yahoo quote server returns 1
How to load text into Excel from web? 3
How to load web page into Excel properly? 2
.csv problem? 1
A question about classic asp 3
How to import external data into excel? 2

Back
Top