web page certificate

Posted on 2009-05-21
Medium Priority
Last Modified: 2013-11-26
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 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
            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
          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

Question by:RGuillermo
LVL 31

Accepted Solution

Paranormastic earned 2000 total points
ID: 24442266
I think all you need to do is change the URL in line 14 & 30 from https: to http:

Alternatively, you could suggest that they get a new cert from godaddy - its US$30/year - not very spendy in comparison

Author Closing Comment

ID: 31583877
Thank you!!!

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Before you approach an Ionic Mobile App development company for developing mobile apps using the ionic framework, you must know why you should choose the framework. Let's try to understand that through this article.
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question