View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Web query against MSN Money

Following your steps, it worked fine for me in Excel 2003

I specified:

http://moneycentral.msn.com/detail/s...ote?Symbol=aig

if I just did

http://moneycentral.msn.com/detail/stock_quote

I could enter the symbol and hit the go button. Then when the table
appeared, hitting import imported the information.

--
Regards,
Tom Ogilvy

"RossR" wrote in message
...
I posted the below to various technical support groups. Anyone have any

ideas?

__________________________________________________ ______

I have been passed across multiple technical support groups, with each
stating that the problem is in another area. This email is being sent to

the
Office, MSN, and Money technical support groups. Surely one of you should

own
the problem.

The problem is with the MSN Money website. I have used Excel web queries

for
years to download financial data. In the last couple of weeks it has

stopped
working BECAUSE A CHANGE HAS BEEN MADE TO THE WEBSITE. I am trying to cut

my
losses at this point and determine if it is temporary, and if anyone is
working on it, or if MSN has decided to not allow download of financial

data.

The simplest description of the problem is as follows:

1. Using a new Excel workbook with no data.
2. Use the Data/Import External Data/New Web Query menu selection.
3. Use the browser window to browse to the data, such as the basic quotes
table in MSN, and select the table.
4. Select Import.

The following message dialog is displayed:

Unable to open http://moneycentral.msn.com/detail/s...ote?Symbol=aig.
The Internet site reports that a connection was established but the data

is
not available.

This occurs every time an import is attempted, and has been occuring for
about the last two or three weeks.

The same query works fine against Yahoo or Morningstar, so the problem is
with the MSN Money website.