How to set auto login id & pasword in excel visual

[mdshakilahmmed]

i want to create command button i using ms excel visual basic.when i am click command button than automatically log in my mail or web page.
here i am set my mail id & password but code didn't work
if it is possible please help me solve this problem.

here is my code didn't work properly.

 Private Sub CommandButton3_Click()
    Dim ie As Object
    Set ie = CreateObject("InternetExplorer.Application")
    ie.Navigate ""
   ie.Visible = True
    Do While ie.Busy And Not ie.ReadyState = 4
        DoEvents
    Loop
   DoEvents
    ie.Document.all.Item("Email").Value = ""
    ie.Document.all.Item("Password").Value = ""
    ie.Document.all.Item("Login").Click
     
End Sub

Thanks
Md Shakil Ahmmed