Hello all,
Using Excel's web query I import Yahoo! data on a daily basis. Since today it seems impossible, both manually as automatically(VBA), to fetch any data. Here's a sample query:
Things I tried:
-Checking the URL via a tracert-command. Works fine.
-Entering the URL in my browser. Works fine, the .csv file will be downloaded.
-Tried a standard web query included in the Excel installation ('MSN MoneyCentral Investor Stock Quotes.iqy'), works fine.
-Reinstalled MS Excel (v2003), problem not solved.
Has anyone the same problem. Can someone try to fire attached web query within Excel?
Thanks for any help,
Jim
Using Excel's web query I import Yahoo! data on a daily basis. Since today it seems impossible, both manually as automatically(VBA), to fetch any data. Here's a sample query:
Code:
Web
1
[url]http://download.finance.yahoo.com/d/quotes.csv?s=AAP&f=a2b2b3b4c1dee7e8e9ghjj1j4j5j6kk4k5l1m3m4m5m6m7m8op2p6rr5r6r7s7t8vy[/url]Things I tried:
-Checking the URL via a tracert-command. Works fine.
-Entering the URL in my browser. Works fine, the .csv file will be downloaded.
-Tried a standard web query included in the Excel installation ('MSN MoneyCentral Investor Stock Quotes.iqy'), works fine.
-Reinstalled MS Excel (v2003), problem not solved.
Has anyone the same problem. Can someone try to fire attached web query within Excel?
Thanks for any help,
Jim