A
Andrew Yates
Hi there,
I'm currently trying to download secure information from xml to excel.
I'm close but not quite there.
Sub newsgroupexample()
Dim code As String
Dim match As String
Dim scode As String
code = "1234"
scode = "b"
Dim objSClient As MSSOAPLib30.SoapClient30
Set objSClient = New SoapClient30
Call
objSClient.mssoapinit(par_WSDLFile:="http://www.thispartisok.wsdl")
fResult = objSClient.KeyData(code, scode) 'it's crashing here
ActiveCell.FormulaR1C1 = fResult
Set objSClient = Nothing
End Sub
The above receives the error "Wrong number of arguments or invalid
property assignment".
Does anybody have any suggestions as to what may be causing the error
and what I may be able to do to fix it. I'm sure that I'm using the
correct number of arguments but I'm unsure as to why I have caused an
"invalid property assignment error".
Any ideas would be much appreciated.
Regards,
Andrew
I'm currently trying to download secure information from xml to excel.
I'm close but not quite there.
Sub newsgroupexample()
Dim code As String
Dim match As String
Dim scode As String
code = "1234"
scode = "b"
Dim objSClient As MSSOAPLib30.SoapClient30
Set objSClient = New SoapClient30
Call
objSClient.mssoapinit(par_WSDLFile:="http://www.thispartisok.wsdl")
fResult = objSClient.KeyData(code, scode) 'it's crashing here
ActiveCell.FormulaR1C1 = fResult
Set objSClient = Nothing
End Sub
The above receives the error "Wrong number of arguments or invalid
property assignment".
Does anybody have any suggestions as to what may be causing the error
and what I may be able to do to fix it. I'm sure that I'm using the
correct number of arguments but I'm unsure as to why I have caused an
"invalid property assignment error".
Any ideas would be much appreciated.
Regards,
Andrew