View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AP[_3_] AP[_3_] is offline
external usenet poster
 
Posts: 33
Default Minimize IE window

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