View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Nick is offline
external usenet poster
 
Posts: 4
Default Controling IE after security popup

Im using the code below to login to a site, but once submit is
clicked, i get the "You are about to be redirected to a connection
that is not secure" popup, is there an automated way to click YES on
that popup, and yes i have the site in my trusted site list, and when
i access the site normally it shows as trusted.

Set ieapp = CreateObject("InternetExplorer.Application")
ieapp.navigate "myurl"
With ieapp.Document
.all("id").Value = "myid"
.all("pass").Value = "mypassword"

Set IPF = ieapp.Document.all.Item("SUBMIT")
IPF.Click
'need to click the YES button on the security popup
end with