A
AP
While in Excel, I use the code below to log in a website.
I would like the Internet Explorer (IE) window to be minimized (but not
invisible) the moment it pops up.
What can I add to the code for the IE window to be minimized?
-----------
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
With ie
.Visible = True
.navigate "https://www.xxx.com"
Do While .ReadyState <> 4: Loop
With .Document.all
.lid.Value = "username"
.pwd.Value = "password"
.submit.Click
Do While ie.ReadyState <> 4: Loop
End With
End With
Set ie = Nothing
I would like the Internet Explorer (IE) window to be minimized (but not
invisible) the moment it pops up.
What can I add to the code for the IE window to be minimized?
-----------
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
With ie
.Visible = True
.navigate "https://www.xxx.com"
Do While .ReadyState <> 4: Loop
With .Document.all
.lid.Value = "username"
.pwd.Value = "password"
.submit.Click
Do While ie.ReadyState <> 4: Loop
End With
End With
Set ie = Nothing