General discussion

Locked

importing data in excel

By pradeepkmr ·
is there a possibility in excel to create a table in which a few columns are updated from the selected website.for example a list of stocks is created in excel and the price of stocks are updated from the net.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

importing data in excel

by DKlippert In reply to importing data in excel

The action is called a "Web Query".
Type Web Query into the search box of the help file. In Excel 2000, you'll see "Create a Web query. Choose that and then click on the hyperlink to "retrieving data from a web page".

Here's some more information

http://officeupdate.microsoft.com/excel/webquery/samples.htm

You can find more details by entering web query in the search box at:

http://msdn.microsoft.com/

Collapse -

importing data in excel

by pradeepkmr In reply to importing data in excel

The question was auto-closed by TechRepublic

Collapse -

importing data in excel

by markshaff In reply to importing data in excel

web querys are okay but most web sites are really protected.
You may have do the import maually.
copy the information on line at a time.
have excell open then when you paste over do not slect the cell to paste the line. Slelect space to right ofthe sum and equal sign ...

Collapse -

importing data in excel

by pradeepkmr In reply to importing data in excel

The question was auto-closed by TechRepublic

Collapse -

importing data in excel

by Vorsossion In reply to importing data in excel

If you are really looking to import stock information you can import it directly from MSN.com into Excel or into MS Money even.

I recommend a book by New Perspectives it has a white cover with a yellow pastel binding. It is called Excel 2000 (shocking, eh?) and can be purchased from www.bn.com or just go to any barnes and noble store for around $19.99. It has plain, easy to use and understand step by step instructions to do anything with Excel. The instructions are listed 1. ... 2. ... etc. in a list which is REALLY nice if you want to skip all the garbage most computer manuals try to feed you.

Collapse -

importing data in excel

by pradeepkmr In reply to importing data in excel

The question was auto-closed by TechRepublic

Collapse -

importing data in excel

by pradeepkmr In reply to importing data in excel

This question was auto closed due to inactivity

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Software Forums