none
Using HTTPS web service via VBA RRS feed

  • Question

  • Hi,

    I could not find the earlier forum for Office 2003 and hence the question to this forum.

    I am currently using Office 2003 and accessing Java based webservices using SOAP. This communication takes place over HTTP and we need to shift to HTTPS.

    I currently have MSXML 2.0 installed which I use for this.

    Can someone please help me understand how my calls will change if the web service is on HTTPS (on a secure layer)? How can I do these calls from VBA?

    Do I need to make any specific changes to my current code?

    Thanks in advance.

    Pranav

    Friday, August 20, 2010 4:14 PM

Answers

All replies

  • Hello Pranav,

    The codes should be same as you call HTTP web services. I see some discussion about this,

    http://www.eggheadcafe.com/software/aspnet/31982899/vba--call-a-webservice-over-https.aspx

    So I think we can head up and see if there come any issues to resolve.

     


    Best regards,
    Ji Zhou - MSFT
    Microsoft Online Community Support

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, August 26, 2010 3:24 AM
    Moderator
  • Hi,

     

    Thanks for the link, however I would like to test this before I could confirm the exact way of using HTTPS. I am planning to test my code base in next couple of weeks.

    Thanks.

    Sunday, August 29, 2010 10:57 PM
  • Hi,

    Im coding in word VBA. I need to access my web service

    When I access it through http, it works fine (from VBA)

    When I access it through https, Im getting problems to access my web service over https.(from VBA)

    -2147024809:WSDLReader:XMl Parser failed at LineNumber 0, lineposition 0, reason is : A secirity problem occured

    HRESULT 0x1 : Incorrect function

    WSDlReader: Loading of the wsdl file failed ......

    When I test the web service directly without using VBA it works fine

    Can anyone plz help


    Tuesday, November 16, 2010 7:28 AM