Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 15th 20, 10:33 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2013
Posts: 28
Default 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

  #3   Report Post  
Old February 16th 20, 01:09 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2013
Posts: 28
Default 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   Report Post  
Old February 17th 20, 10:19 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 86
Default 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



  #6   Report Post  
Old February 18th 20, 04:10 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2013
Posts: 28
Default 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   Report Post  
Old February 18th 20, 04:13 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2013
Posts: 28
Default Web query and script errors

Hi,
Thank you very much for trying to help and for spending your time testing.
  #8   Report Post  
Old February 21st 20, 07:54 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 93
Default 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   Report Post  
Old February 23rd 20, 12:08 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 86
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Script Errors Out Jeff C Excel Discussion (Misc queries) 9 May 20th 07 01:46 AM
Web query errors??? Ryan Jones Excel Discussion (Misc queries) 1 March 13th 06 09:19 PM
Script Errors plainolguy Excel Discussion (Misc queries) 0 February 8th 06 01:42 AM
Web Query Errors Ramthebuffs[_16_] Excel Programming 2 November 20th 05 02:29 AM
Microsoft Script: <x:NameAuto_Close</x:Name causes errors Markus Stolle[_2_] Excel Programming 1 July 30th 04 05:24 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017