One other piece of advice: use arrays rather than Vector to make interoperability easier.
Scott ----- Original Message ----- From: "pop m" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 10:15 AM Subject: VB SOAP Client (Collection, array) Hi ! I am using Tomcat where I have a web app. hwo is capable to communicate via SOAP. I also have a java bean class and one of its methods returns a Vector. I've written a VB client who invokes this method and it works. My problem is that the result I've got is something like this: ******************** Set Reader = New SoapReader Reader.Load Connector.OutputStream If Not Reader.Fault Is Nothing Then MsgBox Reader.faultstring.Text, vbExclamation Else ' here is my result and it works MsgBox Reader.RPCResult.Text End if ******************** and I want to catch this result into a VB Collection or Array, but I didn't enjoy ! I want to do something like this: 'ThisWorkbook.ActiveSheet.Cells.Clear 'ThisWorkbook.ActiveSheet.Range("Bi") = myresult(1) 'ThisWorkbook.ActiveSheet.Range("Cj") = myresult(2) ............................................................... ............................................................... but I can't because the only result I could get is a String and I need an array or collection. Could anyone of you help me ? Thanks in advance ! Pop Marius L.