Set default browser by vba

[Shweta]

Hi All,

I have the below code to login into my gmail account and it is working fine. The problem with this code is it is opening the site in internet explorer but I want to open it in chrome.

Please help how to set the browser with vba code.

Sub test()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")


IE.Visible = True
IE.Navigate "http://www.gmail.com"


While IE.Busy
  DoEvents  'wait until IE is done loading page.
Wend


IE.Document.all("Email").Value = "sss@gmail.com"
IE.Document.all("Passwd").Value = "abc"
IE.Document.all("signIn").Click


End Sub

Thanks in advance!!

Regards,
Shweta

 

[wigi]

Hello

This code will open up Gmail in Google Chrome, but will not do the login unless you let Gmail remember your username and password (my preferred way of working).

Sub test_wigi()

    Shell """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"" -url http://www.gmail.com"

End Sub

Change the Google installation path if needed.