Results 1 to 3 of 3

Thread: VB application working for "http" but not for "https"

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2010
    Posts
    2

    VB application working for "http" but not for "https"

    Hi All,

    I have an application in VBA, with the below code,
    *************************************
    Private Sub CommandButton1_Click()

    On Local Error GoTo errore
    Dim http
    'Dim WinHttpReq As WinHttp.WinHttpRequest
    Dim a As Variant, bbb As Variant, ccc As Variant, ResponseText As Variant

    Dim e As Long
    Dim status As Long


    URL = Sheet1.Cells(6, 3)

    soapPlanRequest = "<SOAP-ENV:Envelope xmlns:SOAP-ENV=""http://schemas.xmlsoap.org/soap/envelope/"" xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xs=""http://www.w3.org/2001/XMLSchema""><SOAP-ENV:Body><pns:findAvailablePlans_R xmlnsns='urn:PlanImpExpAppWSVi'><pns:mode>0</pns:mode></pns:findAvailablePlans_R></SOAP-ENV:Body></SOAP-ENV:Envelope>"
    Set http = CreateObject("WinHttp.WinHttprequest.5.1")
    http.Option(4) = &H3300
    http.Open "POST", URL, False
    http.SetCredentials Sheet1.Cells(3, 3), Sheet1.Cells(4, 3), 0
    http.SetAutoLogonPolicy 0
    http.SetRequestHeader "Content-Type", "text/xml; charset=UTF-8"
    http.Send soapPlanRequest
    status = http.status()
    ResponseText = http.ResponseText

    '
    '
    '
    '

    **************************************************

    The above code was working fine for both "http" & "https" earlier.

    Once after installing TAM authentication certificate the application is not working for "https" but working for "http".

    Please assist me how to resolve this issue.

    Whether to bypass the certificate authentication or someother solution. ?

    Thanks in advance.

    Regards,
    Surendra

  2. #2

    Thread Starter
    New Member
    Join Date
    May 2010
    Posts
    2

    Re: VB application working for "http" but not for "https"

    Hi All,
    Could some one provide solution for the above issue.?

    Regards,
    Surendra P.

  3. #3
    New Member
    Join Date
    Jun 2010
    Posts
    1

    Re: VB application working for "http" but not for "https"

    Great post! It's very nice. Thank you so much for your post.

    __________________
    Watch Splice Online Free

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width