If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Basic Question in Web Query...HELP!!
This is probably a very basic question, but I am stuck and would appreciate
any assistance from the forum. What I am try to do is import stock market data from http://moneycentral.msn.com into an Excel spreadsheet (Excel 2000). The URL is (example): http://moneycentral.msn.com/investor...sp?SYMBOL=MSFT Running a web query dumps the entire webpage onto the spreadsheet, but all I want is one of the values (eg Close). How do I limit the data to just one cell in the external table downloaded to one cell in my spreadsheet?? Sorry for the basic question...there must be a simple way to do this!! |
Thread Tools | |
Display Modes | |
|
|