MSN Stock Quotes help

[David G]

I am trying to do something that I assume is relatively simple. Using Excel
2000, I want to import **ONLY** the "Last Quote" stock quote for a
particular symbol. I have tried the "Data | Get External Data | Run Saved
Query" function, using Excel's built-in query for retrieving staok quote
data from MSN website. However, this function returns the entire detailed
quote tables with all sorts of info that I do not need. Does anyone know
how I go about importing only the "Last Quote" data and nothing else? TIA.

David G-

 

[Don Guillett]

In xl2002, you may edit the query to pull in just the table. You would still
have to copy the ONE cell to another sheet to get JUST the quote. So, import
to one sheet and copy to another.