Web Query Not Working

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
 
G

Gary Groomer

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

Gary
 
D

David McRitchie

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
 
S

saghilar

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:
 
S

saghilar

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL2000 stock price web query stopped working 13
Please help! 2
stock quote query mal-function 3
web query to update stock prices quit working 5
Excel 2000 - Microsoft Investor Stock Quotes.iqy no longer works? 1
Getting External Data with Saved Query 4
What is correct URL for down loading stock quotes in Excel 2000? 1
Basic Question in Web Query...HELP!! 0

Top