R
Rick
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/external/excel/quotes.asp?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!!
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/external/excel/quotes.asp?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!!