I want to open a hyperlink in chrome only.
please suggest a way to write macro.
I have tried below code of VBA, but it is not working.
Sub OpenMyURL()
ChromeLocation = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
MyURL = "https://www.google.com" 'URL that you would like to open; you may also use a variable for this, or a pointer to the location of the URL
Shell (ChromeLocation & " -url " & MyURL)
End Sub
Error is Type Mismatch - Shell.
Please suggest if there is any other way.
