| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to load data into excel?
Does anyone have any suggestions on how to load data into excel?
There is the link for data http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to load data into excel?
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. -- Kevin Backmann "Eric" wrote: Does anyone have any suggestions on how to load data into excel? There is the link for data http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to load data into excel?
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 "Kevin B" wrote: 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. -- Kevin Backmann "Eric" wrote: Does anyone have any suggestions on how to load data into excel? There is the link for data http://download.finance.yahoo.com/d/...1c1ohgv&e=.csv Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to load data into excel?
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 On Mon, 9 Mar 2009 05:36:00 -0700, Eric wrote: Does anyone have any suggestions on how to load data into excel? There is the link for data http://download.finance.yahoo.com/d/quotes.csv Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get excel to load data from a multiple sheet displaying | Excel Discussion (Misc queries) | |||
| Saving excel data to load into word | Excel Worksheet Functions | |||
| How to load data from excel file through Internet? | Excel Discussion (Misc queries) | |||
| How to load data from excel file through Internet? | Excel Worksheet Functions | |||
| Macro to Load Data from ver 1 to ver 2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
