#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default xml bug

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"