+ Reply to Thread
Results 1 to 16 of 16

Change Default Browser for Excel Web Query

  1. #1
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Change Default Browser for Excel Web Query

    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
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Change Default Browser for Excel Web Query

    Check the settings under the Start Button, Default Programs, Set program access and computer defaults. In the same area check Set your default programs. There are defaults for both Chrome and IE...maybe they are not set up to do what you want. There are extensions under both programs that I am not familiar with so don't know if any of them would affect the Data Connections.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Change Default Browser for Excel Web Query

    You can't use Chrome to do a web query, only the built in IE tool. I *think* you can publish a google sheet to xml, you should be able to import from that

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Change Default Browser for Excel Web Query

    I think that I may have found what controls this behaviour.

    In the Default Programs that I mentioned earlier, in the section Set Associations, there is an entry for Web Query and the extension is .igy which is set on my computer to Excel. If you select this entry then click on Change Program, there is an opportunity to browse for the program that you want.....maybe this will work for you.

  5. #5
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Re: Change Default Browser for Excel Web Query

    @newdoverman

    Very sorry. Completely forgot to mention that I'm doing this on a computer on which I do not have sufficient privileges to alter the settings there.

    Really appreciate your help and sorry for messing you about.

    Regards

  6. #6
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Re: Change Default Browser for Excel Web Query

    Quote Originally Posted by Kyle123 View Post
    You can't use Chrome to do a web query, only the built in IE tool. I *think* you can publish a google sheet to xml, you should be able to import from that
    Ok, this might be an option. Thanks.

    Do you have any idea how I might go about doing this via VBA?

    If necessary, I can get this post moved to a different subforum.

    Thanks a lot for your help.

    Cheers

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Change Default Browser for Excel Web Query

    Quote Originally Posted by XOR LX View Post
    @newdoverman

    Very sorry. Completely forgot to mention that I'm doing this on a computer on which I do not have sufficient privileges to alter the settings there.

    Really appreciate your help and sorry for messing you about.

    Regards
    No problem, I hope that you get an answer.

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Change Default Browser for Excel Web Query

    Yes and No, it's doable with VBA but hard due to the type of authentication in place.

    My suggestion was to skip the VBA, publish the sheet with a link and use the resulting output to do a web query one

  9. #9
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Re: Change Default Browser for Excel Web Query

    Ah, ok.

    And is this alternative that you're suggesting something that can be automated to a certain extent? If so, can you give me some pointers? If not, then I guess I'm no better off and may as well just manually download the .xlsx from the Sheets version!

    Regards

  10. #10
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Change Default Browser for Excel Web Query

    Once you've published your worksheet, you should be able to set up a web query to the published page in the normal way - it's not the google sheets app so there's no requirement for > ie8. Then it's just a case of refreshing the sheet

  11. #11
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Re: Change Default Browser for Excel Web Query

    Not quite sure what you mean here. My knowledge of Google Sheets is woefully poor!

    But if this "publishing" is something which will conflict with the Google Sheet being set so that it is not public, but restricted to "anyone with a link can view", then I'm afraid it won't be an option.

    Apologies. I should've mentioned this specification earlier, though I didn't think it would matter.

    Regards

  12. #12
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Change Default Browser for Excel Web Query

    Sorry, I don't understand you.

    Can you or can't you share with "anyone with a link can view"?

    If you can then it will work, if you can't then it won't

  13. #13
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,428

    Re: Change Default Browser for Excel Web Query

    Really sorry - this is all new to me. I'm not sure what you mean by either "publish" or "share".

    I think I should do a bit of studying on Google Sheets so that I can understand a bit better what you mean then come back to you.

    Cheers

  14. #14
    Registered User
    Join Date
    11-05-2012
    Location
    Aiken, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Change Default Browser for Excel Web Query

    This is an old thread, but in case you never got an answer (I never have on somethings) Excel 2010, File > options > Advanced; scroll to the bottom. Under the General line there is a Web Options button... That opens a dialog box, switch to the Browsers tab and at the top dropdown "People who use this web page will be using..." you can switch to an earlier verison of internet explorer. Hope that helps.

  15. #15
    Registered User
    Join Date
    11-18-2018
    Location
    DA NANG, VIET NAM
    MS-Off Ver
    2013
    Posts
    1

    Re: Change Default Browser for Excel Web Query

    Quote Originally Posted by donfaison View Post
    This is an old thread, but in case you never got an answer (I never have on somethings) Excel 2010, File > options > Advanced; scroll to the bottom. Under the General line there is a Web Options button... That opens a dialog box, switch to the Browsers tab and at the top dropdown "People who use this web page will be using..." you can switch to an earlier verison of internet explorer. Hope that helps.
    Thanks,I use Office 2013, but it's not select choose version IE newer, i need IE ver 8 or above:
    2018-11-19_10-35-47.jpg
    Last edited by MDM1088; 11-18-2018 at 11:59 PM.

  16. #16
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Change Default Browser for Excel Web Query

    When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

    (link above in the menu bar)

    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-04-2012, 06:03 AM
  2. Changing default browser for Excel
    By cleary71 in forum Excel General
    Replies: 0
    Last Post: 08-10-2010, 09:06 AM
  3. Any way to make Excel use a non-default browser?
    By Delta223 in forum Excel General
    Replies: 2
    Last Post: 07-30-2010, 03:00 AM
  4. Web hyperlinks: default browser and resulting browser window size?
    By gjh3124@yahoo.com.au in forum Excel General
    Replies: 4
    Last Post: 05-18-2006, 11:25 PM
  5. [SOLVED] how do web query excel 2003 from site in browser?
    By Sayville Library in forum Excel General
    Replies: 0
    Last Post: 05-03-2006, 03:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1