Good morning everyone. I'm having trouble creating a VBA macro that logs into the site. I'm trying on a test site link . So far I only managed to open the site with a button command in excel, but I need the same, login. Can you help me?
Follow the code below
Private Sub CommandButton1_Click()
Dim ie As Object
Dim PaginaWeb As String
PaginaWeb = "http://excelevba.com.br/download/login_teste.php"
Set ie = CreateObject("InternetExplorer.application")
ie.navigate PaginaWeb
Do While Not ie.busy
Loop
'Do While ie.ReadyState <> 3
'DoEvents
'Loop
ie.Visible = True
'si se quiere cerrar la ventana
'ie.quit
Set ie = Nothing
End Sub