Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
Hi,
I have a problem when trying to access the web page "https://borsen.dk/investor/kurser/danske-aktier/" through Excel web query. I constantly get script errors and cannot complete my Excel job. Accessing the web page the normal way through browser is no problem. In Internet Explorer I have already done the following without success: 1. Disabled script debugging 2. Disabled notifications about script errors I hope someone has a solution to the problem. This might as well include vba code. Thanks in advance. I am using: Windows 7 Office 2007 Internet Explorer 11 and Google Chrome Kind regards, Kaj Pedersen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
I followed your advice but are sorry to say that I still get the same script
error pop up using FireFox. You can easily try it yourself if you want. ExcelDataweb query (and insert my link) I still hope and will be happy if someone else has a better solution to the problem. Thank you. Regards Kaj Pedersen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
wrote in message
I followed your advice but are sorry to say that I still get the same script error pop up using FireFox. You can easily try it yourself if you want. ExcelDataweb query (and insert my link) I still hope and will be happy if someone else has a better solution to the problem. Thank you. Regards Kaj Pedersen I had a quick go: In 2007 it simply failed like you. In 2010 got several script error messages each with OK/Cancel, I OK'd all the way through, got a small part of the page in Col-A only but nothing useful. In 365 got a cryptic message about the page being set for IE11 compatibility mode but couldn't display anything from the page either in 'table' or 'web' view. I have no idea what the problem is. There's a contact link, why not ask if an Excel web query is possible, or 'get and transform' in later versions. Peter T |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
wrote:
I followed your advice but are sorry to say that I still get the same script error pop up using FireFox. You can easily try it yourself if you want. ExcelDataweb query (and insert my link) I still hope and will be happy if someone else has a better solution to the problem. Thank you. Regards Kaj Pedersen I've never used that feature but tried it in 365 and FWIW got as far as shown in these two screenshots: https://www.dropbox.com/s/hd9znuwjh8...ry-1.jpg?raw=1 https://www.dropbox.com/s/bqrpymh2ml...ry-2.jpg?raw=1 Terry, East Grinstead, UK |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
Hi,
Thank you very much for trying to help and for spending your time testing. I have now come to the conclusion that these script errors occur because of restrictions related to the actual homepage and there is nothing one can do to eliminate them. Using another browser as standard browser does not make any difference. Web queries in Excel 2007 is always tied to Internet Explorer and cannot be changed. Doing the same web request to other web pages can be carried out without any problems. Kaj Pedersen |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
Hi,
Thank you very much for trying to help and for spending your time testing. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
Terry Pinnell wrote:
wrote: I followed your advice but are sorry to say that I still get the same script error pop up using FireFox. You can easily try it yourself if you want. ExcelDataweb query (and insert my link) I still hope and will be happy if someone else has a better solution to the problem. Thank you. Regards Kaj Pedersen I've never used that feature but tried it in 365 and FWIW got as far as shown in these two screenshots: https://www.dropbox.com/s/hd9znuwjh8...ry-1.jpg?raw=1 https://www.dropbox.com/s/bqrpymh2ml...ry-2.jpg?raw=1 * So this is eXplicitly stating that that version of IE is crap. One can run IE11 in Win7 reasonably well and it seems to be compatible for older "needs", and should work "normally" in Win10. I do not keep up with this newer M$ crap, but i think "Edge" s the next one. If you system has some version of Win10 it may take Edge and run it in compatibility mode. Experiment. Since the program is 200% Micro$uck, you are stuck with use of (on of) their browsers. Terry, East Grinstead, UK |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query and script errors
"Robert Baer" wrote in message
https://www.dropbox.com/s/hd9znuwjh8...ry-1.jpg?raw=1 https://www.dropbox.com/s/bqrpymh2ml...ry-2.jpg?raw=1 * So this is eXplicitly stating that that version of IE is crap. One can run IE11 in Win7 reasonably well and it seems to be compatible for older "needs", and should work "normally" in Win10. I do not keep up with this newer M$ crap, but i think "Edge" s the next one. If you system has some version of Win10 it may take Edge and run it in compatibility mode. Experiment. Since the program is 200% Micro$uck, you are stuck with use of (on of) their browsers. Whilst you've obviously got your own very strong reasons for disliking IE I think it's misplaced to rely on them for making conclusions about the particular issue here, at least without relevant evidence to support for the particular issue with the Excel web query. The web page loads fine in IE in Win7 and Win10 so the issue is clearly not specifically an IE 'browser' problem as you assert. I tested in Win10 + Excel 365, there was no indication of which engine or whatever behind the scenes it uses to extract data from a web query, presumably Edge perhaps with some IE but no way to tell. From what I can make out here the problem is this metatag in the web page: X-UA-Compatible content= IE=Edge However from a quick search maybe the problem would be solved the tag in the html was replaced with this: X-UA-Compatible: IE=edge. Only a guess! Peter T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script Errors Out | Excel Discussion (Misc queries) | |||
Web query errors??? | Excel Discussion (Misc queries) | |||
Script Errors | Excel Discussion (Misc queries) | |||
Web Query Errors | Excel Programming | |||
Microsoft Script: <x:NameAuto_Close</x:Name causes errors | Excel Programming |