Hello,
I know there is possibility to login into gmail using macro, but I am not able to log there
I have this macro :
Sub gmail()
Const MyUrl As String = "http://gmail.com"
Const PostUser As String = "Email=My_mail"
Const PostPassword As String = "&Password=pass"
MyPost = PostUser & PostPassword
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & MyUrl, Destination:=Cells(1, 1))
.PostText = MyPost
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
but it only save login page into excel, I know there is possibility tu use IE but I need to use only excel, I will appreciate any help, thanks !
Bookmarks