Web Query Not Working

  • Thread starter Thread starter Gary Groomer
  • Start date Start date
G

Gary Groomer

Up until yesterday, my web query in my Excel worksheet has been working
perfectly. I have been using the saved query named "Microsoft Investor
Stock Quotes.iqy". It looks like the server accessed by the URL has been
down. When I ping the domain, I get the message that the ping timed out.
The link used by the query is
http://investor.msn.com/external/excel/quotes.asp?SYMBOL=AA,fdx... Is
anyone else experiencing the same problem? Does anyone know how to contact
MSN to jog them to get things up and running? Or, have they stopped
supporting the query?

Gary
 
My thanks to Jason for the solution. It would be nice if Microsoft would
inform user of changes!

Gary
 
To find where to change your code, I think the article that Jason's
fix is for is or is similar to this one:

Different Ways of Using Web Queries in Microsoft Office Excel 2003

http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xlWebquery.asp?frame=true

-- so much for Microsoft being less likely to change something that
would affect an example related to one of their own products, though
actually it wasn't a format that was changed it was a URL and it
certainly is not unusual for a Microsoft URLs to go stale after six
months.

BTW, to see Jason's answer without truncation in Google you may have to
choose "Options" and then "Show Original"

David McRitchie
 
Where can I change the url below? if I change it by the button 'edit
query' I can't reach the new url (i receive Page not found)

If I paste the new url below it works! but I can't use my original
query that extracts symbols stock from a range in excel and not from
the url.
anyone can help me?
many thanks



(e-mail address removed) ha scritto:
 
OK OK
It works
thanks to Jason for new url

It's very strange that MS didn't advise about this problem

saghilar ha scritto:
 
Back
Top