Link to home
Start Free TrialLog in
Avatar of RGuillermo
RGuillermoFlag for United States of America

asked on

web page certificate

Hello experts.
The following code works fine with the webpage indicated. Now the company owner of the webpage is not interested in renewing their certificate for the time being. With the certificate invalid the code does not work and operators now should go manually to the webpage.
Is there any adjustment I can do on the code so will work again?
I have noticed that when you go manually to the webpage initially you get the invalid certificate message but also a button to continue. And the you continue and the page works,
How can I modify my code to do the same?
I am getting state=3 right now.
Best regards,

Option Explicit
Dim w_azv_cod As String, w_int_nam As String, w_pat_cod As String
 
Private Sub Command2_Click()
  Dim x2 As String
  x2 = "...processing..."
  Text2.Text = x2
  Text3.Text = x2
  Text4.Text = x2
  Text5.Text = x2
  Text6.Text = x2
  w_azv_cod = Trim(Text1.Text)
  With Inet1
      .Execute "https://www.uoazv-online.aw/azvonline/index.php?option=com_vest&task=resultdetail '_blank'>https://www.uoazv-online.aw/azvonline/index.php?option=com_vest&task=resultdetail", "POST", "txtrn=" + w_azv_cod, "Content-Type: application/x-www-form-urlencoded"
  End With
End Sub
 
Private Sub Form_Load()
  Dim a As Integer, w As String
  
  Open "c:\tmp\azv_cod_txt.txt" For Input As #1 Len = 100
  Input #1, w
  w_pat_cod = Trim(w)
  Input #1, w
  w_azv_cod = Trim(w)
  Input #1, w
  w_int_nam = Trim(w)
  Close #1
  With Inet1
      .Execute "https://www.uoazv-online.aw/azvonline/index.php?option=com_vest&task=resultdetail '_blank'>https://www.uoazv-online.aw/azvonline/index.php?option=com_vest&task=resultdetail", "POST", "txtrn=" + w_azv_cod, "Content-Type: application/x-www-form-urlencoded"
  End With
End Sub
Private Sub Command1_Click()
  End
End Sub
 
Private Sub Inet1_StateChanged(ByVal State As Integer)
    Dim Result As Variant, LIN(7) As String, part As String, na As String
    If State = 12 Then
        Do
            part = Inet1.GetChunk(100, icString)
            Result = Result & part
        Loop Until Len(part) = 0
        If InStr(1, UCase(Result), UCase("Er zijn geen verzekerden"), vbTextCompare) Then
          na = "Relatie No. not registered."
          Text1.Text = w_azv_cod
          Text2.Text = w_int_nam
          Text3.Text = na
          Text4.Text = na
          Text5.Text = na
          Text6.Text = na
          Text7.Text = na
        Else
          LIN(1) = Split(Split(Split(Split(Result, "<table")(5), "</tr>")(1), "<b>")(1), "</b>")(0)
          LIN(2) = Split(Split(Split(Split(Result, "<table")(5), "</tr>")(2), "<b>")(1), "</b>")(0)
          LIN(3) = Split(Split(Split(Split(Result, "<table")(5), "</tr>")(3), "<b>")(1), "</b>")(0)
          LIN(4) = Split(Split(Split(Split(Result, "<table")(5), "</tr>")(4), "<b>")(1), "</b>")(0)
          LIN(5) = Mid(Result, InStr(1, UCase(Result), UCase("Deze informatie is geldig op:"), vbTextCompare) + 31, 60)
          LIN(5) = Mid(LIN(5), InStr(1, LIN(5), "<b>") + 3, 11)
          Text1.Text = w_azv_cod
          Text2.Text = w_int_nam
          Text3.Text = LIN(1)
          Text4.Text = LIN(2)
          Text5.Text = LIN(3)
          Text6.Text = LIN(4)
          Text7.Text = LIN(5)
          ' MsgBox Split(Split(Split(Split(Result, "<table")(6), "</tr>")(1), "<b>")(1), "</b>")(0) & vbLf & _
          '        Split(Split(Split(Split(Result, "<table")(6), "</tr>")(2), "<b>")(1), "</b>")(0) & vbLf & _
          '        Split(Split(Split(Split(Result, "<table")(6), "</tr>")(3), "<b>")(1), "</b>")(0) & vbLf & _
          '        Split(Split(Split(Split(Result, "<table")(6), "</tr>")(4), "<b>")(1), "</b>")(0)
        End If
    End If
End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Paranormastic
Paranormastic
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RGuillermo

ASKER

Thank you!!!