Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error in Excel VBA connecting to Web Service

166 views
Skip to first unread message

Kien

unread,
Mar 22, 2005, 7:41:05 AM3/22/05
to
Hi All, I'm using Ms SOAP toolkit 3 to connect Excel to my web service. All
the while, it works fine on all the machines. But don't know why recently
there are few machines that hit the error below:

WSDLReader:XML Parser failed at linenumber 0, reason is :The system cannot
locate the resource specified.
HRESULT=0X1:Incorrect function
- WSDLReader:Loading of the WSDL file failed
HRESULT=0X80070057: The parameter is incorrect.
- Client:One of the parameters supplied is invalid.
HRESULT=0X80070057: The parameter is incorrect.

This really sounds mystery while it only happened on a few machines..but not
ALL, majority machines are working fine.

My code that used to connect web service in Excel VBA are like this:

Private Sub Class_Initialize()
Dim str_WSML As String
str_WSML = ""
Set sc_eSFExcel1 = New SoapClient30

sc_eSFExcel1.MSSoapInit2 c_WSDL_URL, str_WSML, c_SERVICE, c_PORT,
c_SERVICE_NAMESPACE
sc_eSFExcel1.ConnectorProperty("ProxyServer") = "<CURRENT_USER>"
sc_eSFExcel1.ConnectorProperty("EnableAutoProxy") = True

End Sub

Can anybody help on this? Million Thanks.

Best Regards,
Kien

cvamin

unread,
Apr 25, 2005, 4:08:55 PM4/25/05
to

Kein,

I am facing similer problem. Have you find the solution to this?

cv

--
cvamin
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

lgarzaro

unread,
Apr 10, 2012, 2:53:23 AM4/10/12
to
I have the same problem.. Did you know if in the other machines are using your
excel have Excel 2010. cuz this is the reason why my excel doesn't work cuz i'm
triying to pass excel 2007 to 2010 and it doesn't work
0 new messages