+ Reply to Thread
Results 1 to 2 of 2

Selecting Browser for Individual Links?

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    TX
    MS-Off Ver
    Excel 2010
    Posts
    3

    Selecting Browser for Individual Links?

    Hi All,
    I've got a spreadsheet with links to different financial websites; I like to use Chrome as default browser, but some of these sites have problems with Chrome and so I use IE for them. The problem, though minor, is that I have to copy/paste the link into IE. It would be great to keep Chrome as default for links (like I do now), but be able to configure those links that need to open in IE to do so automatically.

    Does anyone know if this is possible with Excel 2010 under Win7? FYI I know nothing about VBA except how to copy and use scripts others have written, so suggesting writing a macro or similar isn't really helpful. Any input is appreciated.

    Thanks!

  2. #2
    Registered User
    Join Date
    08-23-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Selecting Browser for Individual Links?

    Excel will open files in the native default browser.

    You can use a VBA Code such as:

    Quote Originally Posted by Jake Marx View Post
    This will open a link in IE no matter what your default browser is:

    Public Sub gLaunchInIE(rsURL As String)
    Dim ie As Object

    Set ie = CreateObject("InternetExplorer.Application")
    ie.navigate rsURL
    ie.Visible = True

    Set ie = Nothing
    End Sub
    A macro does what you tell it, not what you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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