How to bypass a SSL cerificate programmactially (automatically so a user does not need to know how to do it) when open a secure URL? For example when opening a secure URL, a SSL security certificate pops up.
Here is my code:
Dim strURL
strURL = "https://..."
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True
oIE.Navigate(strURL)
' loop until the page is loaded
While oIE.Busy
Wend
Set oIE = Nothing
I tried the other way which bypasses the security alert but I don't know how to select a button automatically:
Dim strURL
Dim objHTTP
strURL = "https://..."
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objHTTP.SetOption 2, 13056 'Ignore all SSL errors
objHTTP.Open "GET", strURL, False
objHTTP.Send
Set objHTTP = Nothing