View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default MSNStockQuote returns #Value!

Hi Yves,
Does this happen on a single stock quote AND on a multiple stock quote,
have you been using the macro consistently or have you set it aside for a
number of months. There was a problem a few months ago, where as I
recall formats were changed.
http://groups.google.com/groups?thre...gp13.phx. gbl

I'm just the messenger, if those programs are relying on a static web page, forget it, especially
if someone has advertising on a page and figures they can squeeze in more they will. In any
case programming on the output of other printed reports if that is what it is doing is risky
business.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Yves" wrote in message ...
My worksheet has multiple rows with a stock id in the first column. All rows
are properly defined with various data elements provided by MSNStockQuote
functions.

When I run the Update Quotes function (from the toolbar), it updates all
rows except a few for which it set all cells invoking MSNStockQuote with a
#VALUE! code.

Any fix to this erratic behavior?