Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|