dynamic url to browse chrome vba

Question

According to [this link][1], @ray have use the following code to do browsing

shell("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url www.google.com")

While i would like to use dynamic url

Dim url as string
url = "www.google.com/translate"

Dim wholeContent as String
wholeContent =  ""C:\Program Files (x86)\Google\Chrome\Application\chrome.exe - url"" & url
Shell(wholeContent)

next time maybe maps instead of translate.

ignotus · Accepted Answer · 2015-01-28 08:08:25Z

2

Here is a Subroutine to open a url in Chrome (either 32 or 64 bit version) or using the default browser if Chrome can not be found. I hope this helps.

Sub OpenInChromeOrDefaultBrowser(ByVal url As String)

    Dim wholeContent As String
    chrome = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"

    If Dir(chrome, vbNormal) <> "" Then
        '' 32 bit Chrome
        wholeContent = """" & chrome & """ -url " & url
    Else
        '' 64 bit Chrome
        chrome = "C:\Program Files\Google\Chrome\Application\chrome.exe"
        wholeContent = """" & chrome & """ -url " & url
    End If

    If Dir(chrome, vbNormal) <> "" Then
        '' Chrome is found, execute
        Shell wholeContent
    Else
        '' Chrome was not found, open url using the default program
        Dim Sh As Object
        Set Sh = CreateObject("WScript.Shell")
        Sh.Run url
    End If
End Sub

answered Jan 28, 2015 at 8:08

ignotus

6586 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

useR Over a year ago

Hi @ignotus, Thanks for your reply. I don't know how you use ".

ignotus Over a year ago

You have to put the path to chrome between quotes because it contains space character(s). You put escape a quote with another one, so in a string, you have to type "" to contain one quote. See more here: stackoverflow.com/questions/4835691/…

Santosh Over a year ago

@ignotus Nice once

Collectives™ on Stack Overflow

dynamic url to browse chrome vba

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related