Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IE6 and Excel Web Query
Hello,
I am having a problem as outlined below by Excel Guru Peter Benson. Basically Im running Windows 2000 and IE6 with the latest Microsoft updates and know that my problems began a few weeks ago with a security update. This is preventing me from utilizing my excel macro, thus I would like to go back to an earlier version of IE6 or even back to IE 5.5 I know that IE is closely tied to the OS and can be tricky to deal with. Does anyone have any suggesitons as to how I could go back to the base version of IE 6 or even further back in the IE chain? Thanks Matt -------------------------------------------------------------------------- Matt I and many others have exactly the same problem. It's to do with changes made at Yahoo. See my other post on this topic. Their link has changed. If you left click their download link it now loads the data into your browser window rather than giving you the option of saving a CSV file. If you right click you get an error. This error, which you get from within IE, is also preventing web queries from working. I have found this is quite Windows/browser version specific. It may depend on the security patches applied to IE as well. With IE 5.1 I don't have problems. With IE 6.0 with the latest security patches I now (as at a few days ago) cannot get it to work. Send a note to Yahoo -- it's definitly their service that's the problem. But who knows whether it is something intentional on their part or whether it's just a bug which they will fix. "Matt Day" wrote in message ... Hello, I have a web query embedded within a spreadsheet that up until recently was working just fine. It goes out to Yahoo's website and grabs financial data in .csv format and brings it back to the spreadsheet. This macro and connection works fine for others as well as for me at work, but at home I am getting an error message stating that the connection was made but the data was not available. This seems to be related to either my computer or my internet connection. I am currently on Comcast High Speed Internet at home, but others are able to use their cable internet as well as T1 lines to access the info. It will even work on a dial up connection. Does anyone have an idea as to why this could be happening? I have tried power cycling my cable modem to acquire a new connection but that does not seem to help. The interesting thing is that up until today I was able to eventually get the macro to grab the data from the website, but it took many tries. Tonight I am not able to grab the data at all. Even if I try to right click on the cell in the spreadsheet and attempt to just refresh the query, it says: Unable to open. http://finance.yahoo.com/d/quotes.csv?s=.....=.csv and that the internet site reports that a connection was made but the data was not available. Suggestions would be greatly appreciated. I have no idea what would have caused this or why it started. Thanks Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IE6 and Excel Web Query
Matt,
This looks promising... http://cws.internet.com/ie.html Regards, Jim Cone San Francisco, CA "Matt Day" wrote in message ... Hello, I am having a problem as outlined below by Excel Guru Peter Benson. Basically Im running Windows 2000 and IE6 with the latest Microsoft updates and know that my problems began a few weeks ago with a security update. This is preventing me from utilizing my excel macro, thus I would like to go back to an earlier version of IE6 or even back to IE 5.5 I know that IE is closely tied to the OS and can be tricky to deal with. Does anyone have any suggesitons as to how I could go back to the base version of IE 6 or even further back in the IE chain? Thanks Matt -------------------------------------------------------------------------- Matt I and many others have exactly the same problem. It's to do with changes made at Yahoo. See my other post on this topic. Their link has changed. If you left click their download link it now loads the data into your browser window rather than giving you the option of saving a CSV file. If you right click you get an error. This error, which you get from within IE, is also preventing web queries from working. I have found this is quite Windows/browser version specific. It may depend on the security patches applied to IE as well. With IE 5.1 I don't have problems. With IE 6.0 with the latest security patches I now (as at a few days ago) cannot get it to work. Send a note to Yahoo -- it's definitly their service that's the problem. But who knows whether it is something intentional on their part or whether it's just a bug which they will fix. - snip - |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IE6 and Excel Web Query
Wont let me install because a newer version has been detected.... I dont
think I can uninstall IE6... Thanks for trying though. Matt "Jim Cone" wrote in message ... Matt, This looks promising... http://cws.internet.com/ie.html Regards, Jim Cone San Francisco, CA "Matt Day" wrote in message ... Hello, I am having a problem as outlined below by Excel Guru Peter Benson. Basically Im running Windows 2000 and IE6 with the latest Microsoft updates and know that my problems began a few weeks ago with a security update. This is preventing me from utilizing my excel macro, thus I would like to go back to an earlier version of IE6 or even back to IE 5.5 I know that IE is closely tied to the OS and can be tricky to deal with. Does anyone have any suggesitons as to how I could go back to the base version of IE 6 or even further back in the IE chain? Thanks Matt -------------------------------------------------------------------------- Matt I and many others have exactly the same problem. It's to do with changes made at Yahoo. See my other post on this topic. Their link has changed. If you left click their download link it now loads the data into your browser window rather than giving you the option of saving a CSV file. If you right click you get an error. This error, which you get from within IE, is also preventing web queries from working. I have found this is quite Windows/browser version specific. It may depend on the security patches applied to IE as well. With IE 5.1 I don't have problems. With IE 6.0 with the latest security patches I now (as at a few days ago) cannot get it to work. Send a note to Yahoo -- it's definitly their service that's the problem. But who knows whether it is something intentional on their part or whether it's just a bug which they will fix. - snip - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IE6 and Excel Web Query
Matt,
Look what I found... HTTP://SUPPORT.MICROSOFT.COM/?KBID=318378 "How To Reinstall Or Repair Internet Explorer And Outlook Express In Windows Xp" Regards, JimCone San Francisco, CA '------------------- "Matt Day" wrote in message ... Wont let me install because a newer version has been detected.... I dont think I can uninstall IE6... Thanks for trying though. Matt '-------------------------- "Jim Cone" wrote in message ... Matt, This looks promising... http://cws.internet.com/ie.html Regards, Jim Cone San Francisco, CA '---------------------- - snip - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |