Re: Web query against MSN Money

Thanks for both of your replies.

Hmm. It fails for me every time. I wondered if Excel might be corrupted, but
it works every time against other websites. I've tried it with my workbook
that I've been using to download for years, as well as a completely clean
workbook, and get the same results.

The only reason I wanted to stay with MSN is that I've got a lot of
programming behind the workbook for stock analysis that is tied to the MSN
data, primarily all the labels identifying the data, and I didn't want to
spend the time modifying it. If I had it to do over again, I would have used
Yahoo, and may still be forced into that solution.
--
Ross


"Don Guillett" wrote:

> Why use MSN when you know how to use Yahoo which is MUCH better?
>
> --
> Don Guillett
> SalesAid Software
> donaldb@xxxxxxx
> "RossR" <RossR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:053ED54C-6C7B-4728-B1D0-14193FA90573@xxxxxxxxxxxxxxxx
> > 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/stock_quote?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.
>
>
>
.