xml bug

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top