Hi there,
I am trying to run your tip "Refresh Web Data into Excel Every Minute" from 10/10/2005and I am having problems (Excel 2010, Win 7).
Using the URL from the tip (not from the download):
http://finance.yahoo.com/q/cq?d=v1&s=MSFT,+GOOG,+KO,+INTC
and inserting it into a web query I can see the returned page (after GO) and I am able to mark which table I want. However, after pressing Import and setting the data range I am getting following error message:
"The web query returned no data. To change query, click OK, click the arrow on the name box ..., and then click Edit Query."
The URL works without problems in browser ( and I see it in web query definition, as well).
I don't have possibility to check it in Excel 2003 (I guess the tip was written for), but for Excel 2010 it is not working.
So, please, how to configure/change your Tip to make it run in Excel 2010 with the Yahoo! Finance URL?
Thank you in advance.
I am trying to run your tip "Refresh Web Data into Excel Every Minute" from 10/10/2005and I am having problems (Excel 2010, Win 7).
Using the URL from the tip (not from the download):
http://finance.yahoo.com/q/cq?d=v1&s=MSFT,+GOOG,+KO,+INTC
and inserting it into a web query I can see the returned page (after GO) and I am able to mark which table I want. However, after pressing Import and setting the data range I am getting following error message:
"The web query returned no data. To change query, click OK, click the arrow on the name box ..., and then click Edit Query."
The URL works without problems in browser ( and I see it in web query definition, as well).
I don't have possibility to check it in Excel 2003 (I guess the tip was written for), but for Excel 2010 it is not working.
So, please, how to configure/change your Tip to make it run in Excel 2010 with the Yahoo! Finance URL?
Thank you in advance.