VBA - appactivate - not able to send web address to a browser

[musicgold]

Hi,

I am trying to send a web address in the URL box of Chrome using the following code, but it is not working.
The browser is already open showing www.google.com.
Why is it not working?

Thanks

AppActivate "Google" 
SendKeys "^L", False
SendKeys "www.yahoo.com", True
SendKeys {ENTER}

 

[OaklandJim]

I found this at Excel Academy. It works for me.

Sub OpenHyperlinkInChrome()

    Dim sChromeFileLocation As String
    
    Dim sHyperlink As String
    
'   URL/hyperlink to open
    sHyperlink = "https://www.mrexcel.com/"
    
'   Default location of Chrome.
    sChromeFileLocation = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""
    
    Shell (sChromeFileLocation & "-url " & sHyperlink)

End Sub