View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
 
Posts: 334
Default 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!!