> Hi Don
> I'm just about convinced there's a ghost in my machine and I'm about to
> reinstall everything, but before I do would you please do me a favor
> and try this. This code is directly out of KB213730 only substituting
> the Yahoo URL. This runs fine for me the first time but not after
> that. See if it works more than once for you, starting each run with a
> new sheet.
>
> Sub URL_Get_Query()
>
> With ActiveSheet.QueryTables.Add(Connection:= _
> "URL;
http://table.finance.yahoo.com/table.csv? _
> s=ibm&d=6&e=22&f=2006&g=d&a=11&b=16&c=1991&ignore=.csv", _
> Destination:=Range("a1"))
>
> .BackgroundQuery = True
> .TablesOnlyFromHTML = True
> .Refresh BackgroundQuery:=False
> .SaveData = True
> End With
> End Sub
>
>
> Thanks,
> Roy
>
>
>
>
>
>
> Don Guillett wrote:
>> I just tried my program that I offered free on xltraders. It worked just
>> fine.
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1[ at ]austin.rr.com
>> <xltrader100[ at ]yahoo.com> wrote in message
>> news:1153903788.647527.184320[ at ]h48g2000cwc.googlegroups.com...
>> >I posted this problem a week ago on the public.excel.misc group but
>> > didn't get any takers. So, another try.
>> >
>> > I have a Web Query that's been working flawlessly for over a year to
>> > download Yahoo historical quotes, and then one day it decided to work
>> > for only the first query of the day (sometimes not even then), and on
>> > any subsequent queries it gives either a 1004 error or it says: "Unable
>> > to open <URL> ... The Internet site reports that a connection was
>> > established but the data is not available". Except that it looks like
>> > the data actually is downloading because after the Refresh command the
>> > time it take for the error message to pop up is directly proportional
>> > (as measured with a timer) to how may days data I request.
>> >
>> > The URL I'm using is the same one I get if I right click on the
>> > "Download to Spreadsheet" link in Yahoo and copy the link location. If
>> > I enter this URL in a web browser then it works fine, and if I put it
>> > in the formula bar of Excel it makes a hyperlink in the selected cell
>> > which also works fine when followed, so there's nothing wrong with the
>> > URL, but when I use it in a web query it doesn't work (most of the
>> > time). Same problem in both Excel 2k and Excel 2003.
>> >
>> > This is not an unknown problem and has bitten many others over several
>> > years. I don't know if all these are the same problem but Web Queries
>> > seem to be a seriously flakey proposition.
>> >
http://tinyurl.com/oousb>> >
http://tinyurl.com/luq8w>> >
http://tinyurl.com/n58hx>> >
http://tinyurl.com/rrbnt>> >
http://tinyurl.com/olyat>> >
http://tinyurl.com/p88vd>> >
>> > None of the solutions suggested has any effect. I've tried everything
>> > mentioned in these links but nothing helps.
>> >
>> > Here's a procedure I found on public.excel.misc that works, but it only
>> > works (for me) for the first stock on the list. So if my list contains
>> > ibm and aapl, then it will work perfectly on ibm and error out on aapl
>> > at the Refresh statement, and then no more successful downloads until
>> > at least the next day, and sometimes not even then, which is about what
>> > my own program is doing.
>> >
>> >
http://tinyurl.com/muooh>> >
>> > Is it just my machine that this is happening to?
>> >
>> > Anyway, I don't think I should be releasing a commercial product that
>> > relies on Web Queries when they can go wrong so abruptly and
>> > mysteriously. I'm wondering if anybody has a different method for
>> > getting Yahoo historical quotes they'd be willing to share.
>> >
>> > Thanks
>> > Roy
>> >
>