Automatically login to Gmail from excel using VBA

[ranjithkumar8352]

Hello everyone,

I would like to share a topic which has been a question mark for many excel users - how to login to gmail automatically from excel using VBA and the solution is here..

This VBA code is used to login to gmail from Internet explorer.

In my next post i will be posting how to use chrome or firefox for this and it requires installation of a small software, The reason behind why software is to be installed for chrome & firefox and not required for Internet explorer is - IE and Excel are microsoft softwares and so they have inbuilt controls to each other and contrary in case of firefox and chrome.

Here is the VBA code i used

Code:

Dim HTMLDoc As HTMLDocument
Dim MyBrowser As InternetExplorer
 Sub AutoLogin()
 Dim MyHTML_Element As IHTMLElement
 Dim MyURL As String
 On Error GoTo Err_Clear
 MyURL = "http://gmail.com"
 Set MyBrowser = New InternetExplorer
 MyBrowser.Silent = True
 MyBrowser.navigate MyURL
 MyBrowser.Visible = True
 Do
 Loop Until MyBrowser.readyState = READYSTATE_COMPLETE
 Set HTMLDoc = MyBrowser.document
 HTMLDoc.all.Email.Value = Sheets(1).Range("B9").Value
 HTMLDoc.all.Passwd.Value = Sheets(1).Range("B11").Value
 For Each MyHTML_Element In HTMLDoc.getElementsByTagName("input")
 If MyHTML_Element.Type = "submit" Then MyHTML_Element.Click: Exit For
 Next
Err_Clear:
 If Err <> 0 Then
 Err.Clear
 Resume Next
 End If
 End Sub


Note : B9 and B11 are the cells in which Email and password are entered

We can alter this code to make automation to other sites, Please check the attached file for more info.

Regards,
Ranjith

Attachments

Automatic login to gmail.xlsm (70 Kb) Downloaded 651 times

[David_cool]

Thanks a lot ranjith, I've been searching for this     Thank you and waiting to see how it works in chrome  

[ranjithkumar8352]

Thanks a lot ranjith, I've been searching for this     Thank you and waiting to see how it works in chrome  

With pleasure David  

[shyam chegu]

Thanks ranjith,
this is useful for me....
please come out with more of this kind..

[ranjithkumar8352]

Thanks ranjith,
this is useful for me....
please come out with more of this kind..

With pleasure shyam

[Sponsored content]