How do i call my webservice from excel?

[karenros]

Hi..
I have written webservice that uses xmlhttp so that i can save a file in the webserver... But i am not sure as to how to call my webservice in VBA..


Any help will be appreciated.

Thanks,
Karen

[karenros]

This is what i have done right now.. Is this correct..


Dim ws As Object
Set ws = CreateObject("MSSOAP.SoapClient30")
ws.mssoapinit "http://localhost/FileWebservice/Service1.asmx?wsdl", UploadFile(Pict, sType)