Office XP Web Services with DataStage SOA

[winnekj]

I am using Excel to invoke a Datastage RTI job. It's works great when the datastage job returns one row, but I cannot seem to process an array correctly. Has anyone coded VB for handling this? I have a included a snippet below that works for the one row return. Any help is appreciated!

Ken


Dim Info As New clsws_GetTNA
Dim name As String
Dim r_set As String

r_set = Info.wsm_CustomerAssets(name)
Set r_setRange = Range("B6")

r_setRange.Value = r_set