Hi all.
I'm currently attempting to set-up a Web Query in Excel 2010 using Data/Connections/From Web to import data from a particular website (a Google Sheets page, to be precise).
Unfortunately, even though Internet Explorer 8 is not set as my default browser (which is Google Chrome - version 41.0.2272.101), Excel insists on using that for the Web Query, and I do not appear to be able to change it.
The problem is that the page from which I am attempting the import does not support IE8, and so my attempted Web Query fails.
I cannot upgrade my current version of Internet Explorer for my current Windows system, so I am not sure what can be done here.
Does anyone know of any solution to this problem? Is there any way I can insist on Excel using a different browser in such cases? Or a different, general solution which I haven't considered for importing data from a Google Sheet into Excel, bearing in mind that this is something which I am seeking to automate via VBA?
Many thanks in advance.
Regards
Bookmarks